I have a start time and end time in my smartsheet but need to calculate hours worked.  Has anyone used a formula before to do this? if so can you pass along?



How soon do you need this? Time calculations are "coming soon", and the workaround without involves a series of formulas across helper columns. If you need it A.S.A.P. I would be happy to help with just a few questions.


How do you want the end result displayed?

Are you using 12 hour or 24 hour time?

What format are the times entered in?

Are there any breaks that need to be accounted for?