Hi,
How can I sort a column with time values (hh:mm) in chronological order from a particular time, not from the earliest time in the column?
E.g a night shift runs from 19:00 until 07:00. I want to sort rows of times in chronological order from 19:00 until 07:00, not from the earliest time in the table (in this case 00:45) onwards.
I don't want to use vba.
Thanks in advance.
How can I sort a column with time values (hh:mm) in chronological order from a particular time, not from the earliest time in the column?
E.g a night shift runs from 19:00 until 07:00. I want to sort rows of times in chronological order from 19:00 until 07:00, not from the earliest time in the table (in this case 00:45) onwards.
I don't want to use vba.
Thanks in advance.