Adding hours and minutes

Team Orbie 9

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

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)? 

Team Orbie 9

Hi Chris,

Thank you. They are HH:MM values.