I created a single line text column to record the time in HH:MM:SS AMPM
But now I need it to sort properly.
It's sorting in numerical order but not in actual chronological order.
so for example (ascending sort order)
where the 4pm item should be last.
Can I remedy this with a calculated column?