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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!