Format as time

Tash

I need to keep accurate documentation of how long my deliveries take (down to the minute) I normally do this in spreadsheets by having the column formatted as a time. I cannot see that option in the formatting list. Am I blind or is it not there?

Andrée Starå

Hi Tash,

Unfortunately, Smartsheet doesn't have a Time specific column just yet, but it's coming.

A workaround could be to use a dropdown list, and it's also possible to set up a solution where you can select the start time and end time to calculate the total time.

Another option could be a time measuring add-ons/plugin that you can use together with Google Chrome.

Can you describe your process in more detail so that I can maybe give you a better recommendation?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

ErinMay

Is this still not an option?

Andrée Starå

Hi @ErinMay

I hope you're well and safe!

Unfortunately, it's not released yet, but hopefully, it will be released soon.

Please submit an Enhancement Request when you have a moment.

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sheryl Roland

I had to add a lot of helper columns to make a workaround. My first column is the start timestamp. My next 3 helper columns break down the hour and minutes then convert them to decimal. I do the same thing with my end timestamp. Then I do the calculation. I also have to reconvert it to minutes for another project. Seems like a lot of work, but once it's done, it's done. It's definitely ugly, but it does the trick until SmartSheet can figure out how to make it a standard function. Hope it helps.

TimeStart           Start Hour          Start Min            Start Convert

13:18                   13                          18                          13.30

Start Hour =LEFT(TimeStart@row, 2)

Start Min =RIGHT(TimeStart@row, 2)

Start Convert =VALUE([Start Hour]@row) + (VALUE([Start Min]@row) / 60)

TimeEnd             End Hour            End Min              End Convert

14:38                    14                          38                          14.63

End Hour =LEFT(TimeEnd@row, 2)

End Min =RIGHT(TimeEnd@row, 2)

End Convert =VALUE([End Hour]@row) + (VALUE([End Min]@row) / 60)

Resp Time          Resp Mins

1.33                       80

Resp Time =IF([End Convert]@row >= [Start Convert]@row, [End Convert]@row - [Start Convert]@row, [End Convert]@row + 24 - [Start Convert]@row)

Resp Mins =IF([Resp Time]@row > -1, [Resp Time]@row * 60, [Resp Time]@row + 1440)