Time function

I need to record hours in HH:MM in one of the columns of my sheet is there a time format or formula I can use so that entry format is HH:MM . I will not be tracking time in and time out, just the total time worked, for instance, if John Doe worked 7hrs and 20mins, I want to be able to enter 07:20, is this possible?

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    I would suggest inserting an additional helper column for each HH:MM column. The thread above has a solution for converting HH:MM into a useable number. Then you can sum these helper columns, and there is a solution in the above thread that details how to convert a number back into HH:MM format for display.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!