Time Column

Majid Kayani

Hi ,

I was wondering if there is a function to have a time Column?

Garrett Henke

There is no dedicated time column type. However use a Text/Number column type to enter time format '9:30am' as an example. This is what you will use for the formula that i shared on your other post

Majid Kayani

not getting it to work sorry. please could ask for you to break it down.

real newbie to this.

Paul Newcome

You would need to manually enter the time into a text/number column.

Majid Kayani

hi @Paul Newcome thank for the comment. is it possible I could discuss a couple of items with you regarding Smartsheet's and i have notice you have made plenty of assistance with other users.

Paul Newcome

You are welcome to tag me in various threads and posts that you may need assistance with. I am always happy to help out here in the community.

Matt Faix

@Paul Newcome Do you know if this (the availability of a time column) has changed at all since earlier in the year? If not, does using the time format you mentioned above allow you to sort? Thanks

Paul Newcome

@Matt Faix Manually entering a time such as 12:52pm or 18:43 will always output a text value which won't sort based on the actual time. You would need to go through the below linked thread and find the solution that converts the manually entered time into a usable number which would then be sortable.

https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time