Time Tracking - Hours and Minutes

Ezra
Ezra ✭✭✭
edited 12/09/19 in Formulas and Functions

I was working on a way to track some task hours and minutes... came up with this:

One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore preceding zeros, it would save a lot of IF statements (see [Start Time] and [End Time] columns)

https://app.smartsheet.com/b/publish?EQBCT=90d9dcad6ed246a89a1dbe6cfdce315d

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!