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
Check out the Formula Handbook template!