B
Billy Bob
How to sort using date and then time in an "a" and "p" format for Excel
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Umlas, Excel MVP
A normal sort should to what you want. Nothing special here...
Bob Umlas
Excel MVP
Bob Umlas
Excel MVP
B
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
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
B
Billy Bob
Billy Bob said:How to sort using date and then time in an "a" and "p" format for Excel
B
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
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