Support  Formula that calculates difference between times in a quarterly increments
Hi Smartsheet Community,
I'm attempting to figure out a simple formula that would calculate the difference between 0800 and 0830 in quarterly increments. At this current time i'm unable to figure out how to create a successful formula that would show the correct 0.50 for the following.
Should 0825 and 0900 be entered, the answer should be 0.75
Any assistance would be greatly appreciated. 😊
Answers

0800 or 0830 are texts, so you need to use the text function to get the hour part and minute part and convert it to a number with the VALUE function to calculate the difference.😂
=(VALUE(LEFT([Start Time]@row, 2)) * 60 + VALUE(RIGHT([Start Time]@row, 2))  VALUE(LEFT([End Time]@row, 2)) * 60  VALUE(RIGHT([End Time]@row, 2))) / 60
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!