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

After you sort the data a-z why don't you copy everything before 6:00 and then paste it to the end of your sorted list?

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

Thanks, I will give that a try.

Matt