Time calculation formulate when time goes into another day


We have this formula that is working well to calculate total hours worked. The issue is when the time rolls into the next day. I can get a formula to work great in excel however having troubles here since smartsheet does stuff a bit differently. We do not ask for start date vs end date so only working with time. Does anyone have a solution for this?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!