Calculating the difference in hours:minutes between 2 dates/times

Kacey W

Hello,

I am looking to calculate the different in hours and minutes between two dates and times.

An example would be: Insertion Date/Time - 9/08/23 @ 0800, Removal Date/Time - 9/11/23 @ 1000.

My dates and times are in separate cells. I was able to create a similar workflow in another sheet, but when I try to replicate it in a new sheet, it isn't working out the same.

Thank you!

Kacey

Paul Newcome

Below is a link to a thread that deals with time based calculations in Smartsheet.

Depending on when exactly you need this though, there may be an announcement next week at the ENGAGE event regarding time calculations using a dedicated function. 🤞 I personally would wait (if you can) to see what new features get rolled out next week and then explore your options.

If you need it right now though...

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