How to calculate time in smartsheet

Finops C'ship

Hi,

How to calculate difference in time in smartsheet

for example

Start Time = 12:23:20 and End Time = 20:23:20

I want the difference between this two time in third column = 8:00:00

Paul Newcome

Here is an entire thread dedicated to time based calculations in Smartsheet:

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