Sorting time earliest to latest

These seem like consistent values. Can you convert it to a Single Select field? Single Selects let you define what the sort order for the options are, which your Views can adopt.

Worked a treat, many thanks.

unfortunately, this isn’t an option. As the data is brought in automatically, it needs a single line text field for it to sync properly. What other solutions are there?

Thanks

Then create a single select field, and use an Automation to copy the Text field’s value into it. Sort by the select field.

Use a SWITCH() formula field to convert the strings into a sortable number.

SWITCH( {Due Time},
  "7:00 AM - 9:00 AM", 7,
  "11:00 AM - 1:00 PM", 11,
  "3:00 PM - 5:00 PM", 15
)