sort not working properly ?

[Larry]

Is there a way to get the list below to sort in time sequence?
Notice that the morning times are after the PM times on Friday.
You are looking at 3 columns here. date, hyphen and time.
Time column is formatted as time. Sort is in ascending order,
what is wrong here?
4-24-Thu - 7:30 PM
4-25-Fri - 6:00 PM
4-25-Fri - 8:00 PM
4-25-Fri - 8:00 PM
4-25-Fri - 8:00 PM
4-25-Fri - 8:00 PM
4-25-Fri - 9:00 AM
4-25-Fri - 10:30 AM
4-25-Fri - 12:00 PM
4-26-Sat - 11:00 AM

 

[Buzz Local#30]

Try place the sort in the time colum instaead of date colum? maybe I am not
sure though

 

[Dave]

Hi Larry,
Perhaps the time column is not formatted as time. It seems to be sorting as
text.
Check the format used in that column.
Regards - Dave.

 

[Niek Otten]

You can check the format, but that doesn't tell you if it is text.
The ISTEXT() function will.
You can convert to real Excel time with the TIMEVALUE() function.
Use the date as first sort key and the time as second.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi Larry,
| Perhaps the time column is not formatted as time. It seems to be sorting as
| text.
| Check the format used in that column.
| Regards - Dave.

 

[Tyro]

The sort is working properly. Sorting ascending: 4-25-Fri - 8:00 PM preceds
4-25-Fri - 9:00 AM as 8 preceds 9 in an ascending sort. In your case, you
seem to have text, not Excel date/time values. The sort is done by
evaluating the contents from left to right. If you have true Excel
date/times, and you sort, then format as date/times, the results will be in
the sequence you want with AM preceding PM. You're confusing formatting of
cells with the contents of cells.

Tyro

 

[Larry]

Thanks, Turns out the ones that were not sorting properly were text!
Thanks again