Sum Time Difference in Quarters between 2 Columns

Options

Is there a way to sum the time difference between two columns


There is two columns "Start Time" and "End Time".

If Start Time = 1800 and End Time = 0600, which falls on the next day. I would need it to calculate 12 hours


If Start Time = 1845 and End Time = 0600, which falls on the next day. I would need it to calculate 11.25 hours


Is this possible?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!