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