Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Sort Column based on a Time

Tracy Delpriore
Tracy Delpriore ✭
edited 12/09/19 in Archived 2017 Posts

Is there a way to sort a column that contains a Time.  There doesn't seem to be a way to format the field as Time format, only Date, Text/Number.  And number doesn't work on 12 hour entries.  Any ideas? 

Thank you

· Share on FacebookShare on Twitter

Comments

  • Adam Overton
    Adam Overton Employee

    I don't know of a way to do this normally, but I recently came up with a work around. Make another column, and put this formula in it:

    =((VALUE(LEFT(Time1, FIND(":", Time1) - 1)) + (COUNTIF(Time1, FIND("pm", @cell) <> 0) * 12)) * 60) + VALUE(MID(Time1, FIND(":", Time1) + 1, 2))

    Sort by that column. This assumes your time looks like 9:45 am, or 3:15 pm.

     

     

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories