Sign in to join the conversation:
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
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.
