# Need help with Calculating total time spent with user

I have two columns showing in my smartsheet: one stating - Start Time 08:20am and one for End Time 08:30am I also have another column titled Total Time Spent with User. What formula could i use to get the total time spent with a user? Thank you in advance

I have reviewed other comments on this, but for some reason the formula isn't working for me.

Any help with this would be appreciated!

• ✭✭✭✭✭✭

The best reference for any time formula is this post by @Paul Newcome .

Help?

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• Yeah, I looked at that page and used the formula that he had showing and it's not working.

=INT(SUM@row) + ":" + IF((SUM@row - INT(SUM@row)) * 60 < 10, "0") + (SUM@row - INT(SUM@row)) * 60

• ✭✭✭✭✭✭

@Crystal Bikos If you go to page 1 of that thread, there are multiple hyperlinks that provide various time based solutions. That particular formula you have posted above is pulling data from another column that is the result of a series of other formulas. It is only a very small portion of the overall solution.

If you are unable to find a solution there that works for you or need help adapting one, feel free to let me know, and I will be happy to help when I am able.

@Mark Cronk Thanks for the vote of confidence! It is always nice to know that my solutions are helping other community members.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!