Time difference in 24hr format (HH:MM)

Arjuna Quezada

I need to calculate the time difference between my "Start Time " and my "End Time" and input it into a duration column in minutes. So for Example:

Start Time: 05:55

End Time: 05:59

Difference: 4 Min

Genevieve P.

Hi @Arjuna Quezada

Smartsheet has a TIME function you could use to do this!

https://help.smartsheet.com/function/time

See the example fourth from the bottom:

=(TIME([End Time]@row) - TIME([Start Time]@row)) * 1440

Cheers,
Genevieve