| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sort data Excel 2007
How to sort using date and then time in an "a" and "p" format for Excel
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sort data Excel 2007
A normal sort should to what you want. Nothing special here...
Bob Umlas Excel MVP "Billy Bob" wrote: How to sort using date and then time in an "a" and "p" format for Excel |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sort data Excel 2007
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 "Bob Umlas, Excel MVP" wrote: A normal sort should to what you want. Nothing special here... Bob Umlas Excel MVP "Billy Bob" wrote: How to sort using date and then time in an "a" and "p" format for Excel |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sort data Excel 2007
"Billy Bob" wrote: How to sort using date and then time in an "a" and "p" format for Excel |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sort data Excel 2007
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 "Billy Bob" wrote: 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 "Bob Umlas, Excel MVP" wrote: A normal sort should to what you want. Nothing special here... Bob Umlas Excel MVP "Billy Bob" wrote: How to sort using date and then time in an "a" and "p" format for Excel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Repeat Sort in Excel 2007 | Excel Worksheet Functions | |||
| Sort a column in Excel 2007 | Excel Discussion (Misc queries) | |||
| Pivot Table Data Column Sort Excel 2007 | Excel Discussion (Misc queries) | |||
| sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
| Excel 2007 data corruption using sort within a filter. | Excel Discussion (Misc queries) | |||
Linear Mode
