Adding hours and minutes

Team Orbie 9
Team Orbie 9 ✭✭
edited 12/09/19 in Formulas and Functions

Hello All,

I am new to SS and am trying to figure out how to add these hours and minutes for the year (there will be more added each week). I have found some posts saying this is not possible but they are from last year. Has anyone mastered this issue?

[**Malformed image removed by moderator**]




  • Chris McKay
    Chris McKay ✭✭✭✭✭✭

    Hi Team Orbie 9,

    If you are referring to using MM/DD/YYYY HH:MM:SSS type date formats (e.g. in your [Date] column) to calculate an end time, then no, Smartsheet still (unbelievably) cannot do this out of the box.

    Are your [Time In Transit]:[Total On Time] columns time values (e.g. 00:49 AM), or are do they represent HH:MM values (e.g. 49 minutes)? 

  • Hi Chris,

    Thank you. They are HH:MM values.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!