I'll post another sample which is more relevant to the issue. Shifts begin from 10 pm onto 6 am, please ignore the previous CSV data, on this one anything 22 or 23 would be 10 pm and 11 pm respectively. Anything else eg 01:34 would be 1:34 am.
13-4-2023.xlsx |
---|
|
---|
| A |
---|
2 | 2022-02-19T23:58:00+11:00 |
---|
3 | 2022-02-21T00:23:00+11:00 |
---|
4 | 2022-02-21T23:30:00+11:00 |
---|
5 | 2022-02-23T01:32:00+11:00 |
---|
6 | 2022-02-23T23:49:00+11:00 |
---|
7 | 2022-02-23T23:49:00+11:00 |
---|
8 | 2022-02-25T03:16:00+11:00 |
---|
9 | 2022-02-25T20:11:00+11:00 |
---|
10 | 2022-02-27T00:02:00+11:00 |
---|
11 | 2022-02-27T23:23:00+11:00 |
---|
12 | 2022-03-01T00:40:00+11:00 |
---|
13 | 2022-03-02T03:45:00+11:00 |
---|
14 | 2022-03-03T05:29:00+11:00 |
---|
15 | 2022-03-04T00:10:00+11:00 |
---|
16 | 2022-03-04T23:36:00+11:00 |
---|
17 | 2022-03-06T00:39:00+11:00 |
---|
18 | 2022-03-07T00:55:00+11:00 |
---|
19 | 2022-03-07T22:58:00+11:00 |
---|
20 | 2022-03-08T23:27:00+11:00 |
---|
21 | 2022-03-11T00:43:00+11:00 |
---|
22 | 2022-03-12T00:27:00+11:00 |
---|
23 | 2022-03-13T00:18:00+11:00 |
---|
24 | 2022-03-14T00:04:00+11:00 |
---|
25 | 2022-03-14T23:11:00+11:00 |
---|
26 | 2022-03-15T23:32:00+11:00 |
---|
27 | 2022-03-16T23:21:00+11:00 |
---|
|
---|