Formula to auto calculate time difference in hours between two 24hr format times?


I'm looking for a formula to help me calculate the length of hours an individual has worked. Employees enter their "Haul Start Time" and "Haul End Time" manually by picking from a drop down list of times in 24hr format.

Once picking their starting time and end time, I would like the third column, "Total Hours", to automatically calculate the difference in hours. Right now we are having to manually do the calculation and enter the hours worked. For example I would like the format to be in: 1, 1.25, 1.5 , 1.75 , 2.00 , 2.25 , etc. for the hours worked.

I have attached an image of the columns. Please let me know if you need any other pictures or explanation.

Thank You in advance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!