Calculating Time

Julieh

I am trying to calculate the hours and minutes between a start and and end time. Firstly, what column type should the start and end time columns be, secondly, how should the time be written and thirdly, what formula would I use to calculate the difference between the two columns.

Paul Newcome

Take a look at the TIME function:

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

.