Sort data Excel 2007

[Billy Bob]

How to sort using date and then time in an "a" and "p" format for Excel

 

[Bob Umlas, Excel MVP]

A normal sort should to what you want. Nothing special here...
Bob Umlas
Excel MVP

 

[Billy Bob]

Bob, I entered the dates under "date" and the time under "time". The time
was entered as 10:00a - 2:00p - and 1:00p but it did not sort them. The date
came out correct but I added another level and the sort asked for A - Z. I
finaly went to military time and that worked

 

[Billy Bob]

How to sort using date and then time in an "a" and "p" format for Excel

 

[Billy Bob]

I discovered that it was necessary to enter a new column for "DATE" and one
for "TIME" and then select a date and time format to use. With this done I
entered the information and was able to sort by "DATE" and then "TIME" thus
ending my problem. After the sort I deleted the original columns.

Billy Bob