Sort data Excel 2007

  • Thread starter Thread starter Billy Bob
  • Start date Start date
B

Billy Bob

How to sort using date and then time in an "a" and "p" format for Excel
 
A normal sort should to what you want. Nothing special here...
Bob Umlas
Excel MVP
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting MM/DD/YYYY into just MM/DD and Sorting 1
Sorting by Date 3
Sort behaves unexpectedly 1
Sorting ? 4
Data Sort 1
Data Analysis Tab 1
Sorting day names chronologically 5
"Custom Sort" Question 5

Back
Top