Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting time in a column
I want to sort time in a column using a macro, but instead of the time
running in order from midnight (00:00) I want the starting point to be 06:00 and run until 05:59. At the moment I have the macro copying data and sorting the time a-z and am manually resorting the data. Matt |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting time in a column
How about using a hidden column. In that column use an if formula to
determine if the cell value is 5:59. If so then return 1 otherwise return 0. Now just sort on this column last and you will be in the order you want. Or if you want a macro solution let me know and I can get you the same result that way (using the same general logic) I would want to know how many columns are in your spreadsheet so that I could use one of the unused columns for a sort flag. -- HTH... Jim Thomlinson "mattguerilla" wrote: I want to sort time in a column using a macro, but instead of the time running in order from midnight (00:00) I want the starting point to be 06:00 and run until 05:59. At the moment I have the macro copying data and sorting the time a-z and am manually resorting the data. Matt |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting time in a column
Thanks, I will give that a try. Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Real-time sorting | Excel Discussion (Misc queries) | |||
Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
Sorting a Pivot Table Column that is not the first column... | Excel Worksheet Functions | |||
Right column doesn't change when sorting left column. | Excel Discussion (Misc queries) | |||
how do I convert a date and time column to a time column | Excel Worksheet Functions |