Using a time frame to sort on a report

Ty Werven

I have a report that sorts items based on time. It works fine until I get to items that are at 10,11, or 12. Is it just counting the first digit in the time frame perhaps. Any workarounds?

ChristianFinke

Hey @Ty Werven

The sorting issue occurs because the time frame is likely formatted as text rather than actual time values, causing lexicographical sorting (e.g., "10:00" follows "8:00"). To fix this, reformat the column as Time or Date/Time, split the time frame into separate Start Time and End Time columns, and sort using the Start Time. Alternatively, create a helper column to extract and format the start time as a sortable value. Once updated, reapply the sorting.