| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting time in Excel
I currently use time in the H:MM AM/PM format. I want to sort the time but
instead of starting at 12:00 AM, I want the time to start at 6:00 AM. In other words, I want the times to be sorted as: 6:00 AM 6:30 AM 7:00 AM ..... 11:00 PM 11:30 PM 12:00 AM 12:30 AM And not this: 12:00 AM 12:30 AM .... 6:00 AM 6:30 AM I tried to use a custom sort list but I need to include times in which the minutes will vary. Is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting time in Excel
Use a helper column =MOD(A1-0.25,1) and sort by that.
-- David Biddulph "forest8" wrote in message ... I currently use time in the H:MM AM/PM format. I want to sort the time but instead of starting at 12:00 AM, I want the time to start at 6:00 AM. In other words, I want the times to be sorted as: 6:00 AM 6:30 AM 7:00 AM .... 11:00 PM 11:30 PM 12:00 AM 12:30 AM And not this: 12:00 AM 12:30 AM ... 6:00 AM 6:30 AM I tried to use a custom sort list but I need to include times in which the minutes will vary. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting data/time cell values | Excel Worksheet Functions | |||
| sorting time format | Excel Discussion (Misc queries) | |||
| Sorting data with time stamps | Excel Discussion (Misc queries) | |||
| sorting two columns at the same time | Excel Worksheet Functions | |||
| sorting data by time and day of week | Excel Worksheet Functions | |||
Linear Mode
