Spreadsheet: 714632d1611314102-conditional-formatting-error-on-certain-cells-in-range-book-1
Sheet: Week 44 25-1-21

Week No. |  | W/C Date |  |  | 2021-01-25 00:00:00
No | Start Time | Finish Time | Duration | Duration - MR Removed | Days Operated | Meal Relief | A | B | C | D | E | F | G | H | TOTAL |  | A | B | C | D | E | F | G
1 | 9:00:00 | 17:00:00 |  |  | 5 |  |  |  | 7:15:00 |  | 7:15:00
2 | 23:45:00 | 8:00:00 |  |  | 5 |  |  |  | 7:15:00 |  |  |  |  | 7:15:00
3 | 23:45:00 | 8:00:00 |  |  | 5 |  |  |  | 7:15:00 |  |  |  |  | 7:15:00
4 | 16:00:00 | 1 day, 0:00:00 |  |  | 1 |  |  |  | 7:15:00 |  | 7:15:00
5 | 18:00:00 | 2:00:00 |  |  | 6 |  |  |  | 7:15:00 |  | 7:15:00
6 | 20:00:00 | 4:00:00 |  |  | 1 |  |  |  | 7:15:00 |  | 7:15:00
7 | 21:00:00 | 7:00:00 |  |  | 5 |  |  |  | 9:00:00 |  | 9:00:00
8 | 22:00:00 | 8:00:00 |  |  | 1 |  |  |  | 9:00:00 |  |  |  |  | 9:00:00
9 | 18:15:00 | 2:15:00 |  |  | 1 |  |  |  |  |  | 7:15:00
10 | 12:00:00 | 18:50:00 |  |  | 5 |  |  |  |  |  |  |  | 6:05:00
11 | 16:30:00 | 1:15:00 |  |  | 1 |  |  |  |  |  | 4:40:00 |  | 3:05:00
12 | 18:05:00 | 4:30:00 |  |  | 1 |  | 1:30:00 |  |  |  | 7:55:00
13 | 20:30:00 | 4:30:00 |  |  | 2 |  |  |  |  | 0:35:00 | 6:40:00
14 | 15:55:00 | 23:55:00 |  |  | 5 |  |  |  |  | 4:20:00 |  |  | 2:55:00
15 | 16:05:00 | 1 day, 2:45:00 |  |  | 1 |  |  |  |  |  | 9:40:00
16 | 16:05:00 | 4:30:00 |  |  | 1 |  | 3:00:00 |  |  |  | 7:55:00
17 | 15:35:00 | 1 day, 1:15:00 |  |  | 1 |  | 0:05:00 |  |  |  | 5:10:00 |  | 3:25:00
18 | 10:15:00 | 19:30:00 |  |  | 1 |  |  | 5:10:00 |  |  |  |  | 3:05:00
19 | 15:51:00 | 23:06:00 |  |  | 1 |  |  | 6:30:00
20 | 16:20:00 | 1:39:00 |  |  | 3 |  | 1:02:00 | 3:47:00 |  |  |  |  | 3:30:00
21 | 16:20:00 | 1:39:00 |  |  | 2 |  | 1:27:00 | 3:22:00 |  |  |  |  | 3:30:00
22 | 4:50:00 | 17:35:00 |  |  | 4 |  | 3:05:00 |  |  |  | 4:05:00 |  |  | 4:05:00
23 | 4:50:00 | 15:40:00 |  |  | 1 |  | 2:35:00 |  |  |  |  |  | 3:10:00 | 4:05:00
24 | 4:50:00 | 17:45:00 |  |  | 4 |  | 3:55:00 | 3:50:00 |  |  |  |  |  | 3:40:00
25 | 4:50:00 | 12:50:00 |  |  | 1 |  |  |  |  | 3:20:00 |  |  |  | 3:55:00
26 | 11:35:00 | 19:35:00 |  |  | 2 |  |  |  |  | 0:15:00 | 7:00:00
27 | 9:35:00 | 17:35:00 |  |  | 6 |  |  |  |  | 2:35:00 | 4:40:00
28 | 2:25:00 | 10:25:00 |  |  | 4 |  |  |  |  | 1:20:00 |  |  |  | 5:55:00
29 | 2:25:00 | 14:50:00 |  |  | 1 |  | 3:00:00 |  |  |  |  |  | 2:30:00 | 5:25:00
30 | 3:55:00 | 11:55:00 |  |  | 4 |  |  |  |  | 1:56:00 |  |  |  | 5:19:00
31 | 3:55:00 | 15:20:00 |  |  | 1 |  | 2:36:00 |  |  |  |  |  | 2:30:00 | 5:04:00
32 | 4:50:00 | 12:50:00 |  |  | 5 |  |  |  |  | 2:50:00 |  |  |  | 4:25:00
33 | 4:50:00 | 12:50:00 |  |  | 5 |  |  |  |  | 3:15:00 |  |  |  | 4:00:00
34 | 7:50:00 | 20:25:00 |  |  | 1 |  | 2:30:00 |  |  |  | 5:05:00 |  | 3:30:00
35 | 12:00:00 | 20:00:00 |  |  | 2 |  |  |  |  | 3:45:00 |  |  | 3:30:00
36 | 15:15:00 | 23:15:00 |  |  | 2 |  |  |  |  | 0:35:00 | 6:40:00
37 | 12:05:00 | 20:45:00 |  |  | 3 |  |  | 6:40:00 |  |  | 1:00:00
38 | 16:10:00 | 0:10:00 |  |  | 1 |  |  |  |  | 2:15:00 |  |  | 5:00:00
39 | 4:50:00 | 16:45:00 |  |  | 4 |  | 2:40:00 |  |  |  | 4:40:00 |  | 3:20:00
40 | 4:50:00 | 17:10:00 |  |  | 1 |  | 2:25:00 |  |  |  |  |  | 5:05:00 | 3:20:00
41 | 9:35:00 | 20:09:00 |  |  | 4 |  |  |  |  |  | 9:34:00
42 | 11:45:00 | 22:19:00 |  |  | 4 |  |  |  |  |  | 9:34:00
43 | 13:05:00 | 23:39:00 |  |  | 4 |  |  |  |  |  | 9:34:00
44 | 13:35:00 | 22:45:00 |  |  | 1 |  | 0:30:00 | 6:40:00 |  |  | 1:00:00
45 | 19:50:00 | 7:00:00 |  |  | 1 |  | 1:35:00 | 6:40:00 |  |  | 1:40:00
46 | 10:35:00 | 20:15:00 |  |  | 1 |  | 1:00:00 | 6:40:00 |  |  | 1:00:00
47 | 19:00:00 | 3:00:00 |  |  | 1 |  | 1:35:00 | 4:40:00 |  |  | 1:00:00
48 | 21:15:00 | 5:15:00 |  |  | 1 |  |  |  |  | 0:35:00 | 6:40:00
49 | 17:50:00 | 1:50:00 |  |  | 1 |  |  |  |  | 2:15:00 | 5:00:00
50 | 18:35:00 | 2:35:00 |  |  | 1 |  |  |  |  | 2:35:00 | 4:40:00
51 | 22:20:00 | 6:20:00 |  |  | 1 |  |  |  |  | 0:35:00 | 6:40:00
52 | 11:35:00 | 22:09:00 |  |  | 1 |  |  |  |  |  | 9:34:00
53 | 13:45:00 | 0:19:00 |  |  | 1 |  |  |  |  |  | 9:34:00
54 | 15:05:00 | 1:39:00 |  |  | 1 |  |  |  |  |  | 9:34:00
55 | 19:00:00 | 3:00:00 |  |  | 1 |  |  |  |  | 2:35:00 | 4:40:00
56 | 19:20:00 | 3:20:00 |  |  | 1 |  |  |  |  | 1:50:00 | 5:25:00
57 | 5:30:00 | 13:30:00 |  |  | 5 |  | 7:15:00 |  | 7:15:00
58 | 8:35:00 | 16:35:00 |  |  | 5 |  |  |  |  | 2:35:00 | 4:40:00
59 | 8:35:00 | 16:55:00 |  |  | 1 |  |  |  |  |  | 7:20:00
60 | 23:25:00 | 8:45:00 |  |  | 5 |  | 0:40:00 |  |  |  | 4:25:00 |  |  | 3:15:00
61 | 5:32:00 | 13:32:00 |  |  | 1 |  |  | 4:00:00 |  |  |  |  |  | 3:15:00
62 | 12:20:00 | 20:20:00 |  |  | 4 |  | 1:35:00 | 4:40:00 |  |  | 1:00:00