Need help with Calculating total time spent with user

Crystal Bikos

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!

Mark Cronk

Hi @Crystal Bikos ,

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

https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time

Help?

Mark

Crystal Bikos

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

Paul Newcome

@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.