Support - Formula that calculates difference between times in a quarterly increments

JamesRiosAUS

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. 😊

jmyzk_cloudsmart_jp

@JamesRiosAUS

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

https://app.smartsheet.com/b/publish?EQBCT=4c2c15c72373485780c082cf4c7824d6