Sorting times in chronological order from a specific time

[drefiek2]

Hi everyone,

I have a task list which has around eight columns, including notably the shift ('day' or 'night') and deadline (time formatted as XX:XX) columns. A day shift is 07:00-19:00 and a night shift is 19:00-07:00.

The deadline column is sorted by default when you open the spreadsheet by smallest to largest, which works fine when filtering day shift only. When filtering night shift only, the issue is that it sorts tasks with deadlines from 00:00 first, instead of tasks with deadlines from the shift start time onwards, which is 19:00.

How do I get it so that when filtering night shift tasks only, it will sort from 19:00 through to 07:00 in chronological time order?

Thanks in advance.

 

[Akuini]

Could you please provide some example data along with the expected results? Please use the XL2BB tool to post your example.

 

[drefiek2]

Could you please provide some example data along with the expected results? Please use the XL2BB tool to post your example.

Hi,
Unfortunately I cannot provide as it has confidential information on, let me know if I can better describe the issued.

 

[Akuini]

Hi,
Unfortunately I cannot provide as it has confidential information on, let me know if I can better describe the issued.

Just create dummy data, basically what I need is some data with the hour, also are there dates? and the layout of your data.
I just answered a similar question in this thread:
is-there-a-way-to-sort-time-according-to-a-broadcast-day-6am-6am
see if that helps.