Sorting by Time value

[liampog]

Hi there

I want to sort a range of times in 24 hour format, however, I need to class 00:00 as late rather than early.

For example, I want 00:00 to be displayed later in the sorted list than 23:00.

Any way around this...?

 

[Dryver14]

If possible as data is entered you could use 23:59 for 00:00 or use find and select 23:00 and change to 23:59 for the filter.

Not Ideal I know but using 24:00 changes the format to day and date