Spreadsheet: 619645d1554984321-rota-in-excel-formula-for-creating-daily-overview-based-on-shifts-times-rota-example
Sheet: Sheet4

 |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Jade Redpath | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Nicola Adams | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Tanveer Nawaz | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Holly Wood | [NAME] | Davinder Toor | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] April
 | Monday | 6-2 | 3-11 | 12-8 | 7-3 | 8-4 | R9 | 1-9 | 12-8 | 2-10 | 9-5 | 9-5 | R8 | 10-6 | 8-4 | 7-3 | 10-6 | OFF | R7 | OFF | OFF | 3-11 | 7-3 | 6-2 | R6 | 4-12 | OFF | OFF | 6-2 | 8-4 | R5 | 12-8 | 9-5 | 6-2 | 9-5 | 3-11 | R4 | 10-6 | 7-3 | 4-12 | 8-4 | 12-8 | R3 | 1-9 | 4-12 | 9-5 | 8-4 | 8-4 | R2 | 10-6 | 10-6 | OFF | OFF | OFF | R1 | 8-4 | 7-3 | 2-10 | OFF | 7-3 | 9-5 | R10 | 9-5 | 4-9 |  | 8-2 |  | 8-2 | 6-12 | 9.30-3 | 9.30-2.30 |  |  |  | 9.45-2.45 | 6-11 | 6-2 | 7-3 | 4-12 | 2-10 | R
 | Tuesday | 6-2 | 3-11 | 12-8 | 7-3 | 8-4 | R9 | OFF | OFF | 2-10 | 9-5 | 9-5 | R8 | 10-6 | 8-4 | 7-3 | 10-6 | OFF | R7 | OFF | OFF | 3-11 | 7-3 | 6-2 | R6 | 4-12 | 10-6 | OFF | 6-2 | 8-4 | R5 | 12-8 | OFF | 6-2 | 9-5 | 3-11 | R4 | OFF | 7-3 | 4-12 | 8-4 | OFF | R3 | OFF | 4-12 | 9-5 | 8-4 | 8-4 | R2 | 10-6 | 10-6 | OFF | OFF | OFF | R1 | 8-4 | 7-3 | 2-10 | 10-6 | 7-3 | 9-5 | R10 | 9-5 |  | 8-4 | 8-4 |  | 8-2 | 6-12 | 9.30-3 |  | 8-2 | 9.30-2.30 | 10-4 | 9.45-2.45 | 6-11 | 4-10 | 12-8 | 2-10 | 2-10 | R
 | Wednesday | 6-2 | 3-11 | 12-8 | 7-3 | 8-4 | R9 | OFF | OFF | 4-12 | 9-5 | 1-9 | R8 | 10-6 | 8-4 | 7-3 | OFF | 8-4 | R7 | 10-6 | 4-12 | 3-11 | 7-3 | 6-2 | R6 | OFF | 10-6 | 12-8 | 6-2 | 8-4 | R5 | 12-8 | OFF | 6-2 | 9-5 | 3-11 | R4 | OFF | 7-3 | 4-12 | OFF | OFF | R3 | OFF | 4-12 | 2-10 | 8-4 | 8-4 | R2 | 10-6 | OFF | 8-4 | 10-6 | 4-12 | R1 | 8-4 | 7-3 | 2-10 | 10-6 | 7-3 | 9-5 | R10 | 9-5 | 4-9 |  | 8-4 | 5-11 | 8-2 |  | 9.30-3 | 9.30-2.30 |  | 9.30-2.30 | 10-4 | 9.45-2.45 |  | 4-10 | 12-8 | OFF | OFF | 8-12.45
 | Thursday | 6-2 | 3-11 | OFF | 7-3 | OFF | R9 | 1-9 | 12-8 | 4-12 | OFF | OFF | R8 | 10-6 | 8-4 | 7-3 | OFF | 8-4 | R7 | 10-6 | 4-12 | 3-11 | 7-3 | 6-2 | R6 | OFF | 10-6 | 12-8 | 6-2 | 8-4 | R5 | OFF | 9-5 | 6-2 | 9-5 | 3-11 | R4 | 9-5 | 7-3 | 4-12 | OFF | 12-8 | R3 | 1-9 | 4-12 | 2-10 | OFF | 8-4 | R2 | 10-6 | OFF | 8-4 | 10-6 | 4-12 | R1 | 8-4 | 7-3 | 4-12 | 10-6 | 7-3 | 9-5 | R10 | 9-5 | 5-10 | 8-12 | 8-2 | 5-11 | 8-2 |  |  | 9.30-2.30 | 8-2 | 9.30-2.30 | 9-2 | 9.45-3.45 | 6-11 |  | OFF | OFF | 8-4 | 8-12.45
 | Friday | 6-2 | 3-11 | OFF | 7-3 | OFF | R9 | 1-9 | 12-8 | 4-12 | OFF | OFF | R8 | 10-6 | 8-4 | 7-3 | 10-6 | 8-4 | R7 | 10-6 | 4-12 | 3-11 | 7-3 | 6-2 | R6 | 6-2 | OFF | 12-8 | 6-2 | 8-4 | R5 | OFF | 9-5 | 6-2 | 9-5 | 3-11 | R4 | 9-5 | 7-3 | 4-12 | 8-4 | 12-8 | R3 | 1-9 | 4-12 | 2-10 | OFF | 8-4 | R2 | 10-6 | 10-6 | 8-4 | 10-6 | 4-12 | R1 | 8-4 | 7-3 | 4-12 | OFF | 7-3 | 9-5 | R10 | 9-5 |  | 8-12 |  | 5-11 | 8-12 | 4-10 |  | 9.30-2.30 | 8-2 |  | 9-2 |  | 6-11 | 6-2 | 7-3 | 1-9 | 8-4 | OFF
 | Saturday | OFF | OFF | 3-11 | OFF | 7-3 | R9 | 3-11 | 12-8 | OFF | 3-11 | 6-2 | R8 | OFF | OFF | OFF | 8-4 | 2-10 | R7 | 7-3 | 4-12 | OFF | OFF | OFF | R6 | 8-4 | 4-12 | 9-5 | OFF | OFF | R5 | 6-2 | 7-3 | OFF | OFF | OFF | R4 | 7-3 | OFF | OFF | 6-2 | 12-8 | R3 | 3-11 | OFF | OFF | 8-4 | OFF | R2 | OFF | 8-4 | 2-10 | 7-3 | 4-12 | R1 | OFF | OFF | OFF | 4-12 | OFF | OFF | R10 | OFF |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OFF | 4-12 | OFF | OFF
 | Sunday | OFF | OFF | 3-11 | OFF | 7-3 | R9 | 3-11 | 12-8 | OFF | 3-11 | 6-2 | R8 | OFF | OFF | OFF | 8-4 | 2-10 | R7 | 7-3 | 4-12 | OFF | OFF | OFF | R6 | 8-4 | 4-12 | 9-5 | OFF | OFF | R5 | 6-2 | 7-3 | OFF | OFF | OFF | R4 | 7-3 | OFF | OFF | 6-2 | 12-8 | R3 | 3-11 | OFF | OFF | 8-4 | OFF | R2 | OFF | 8-4 | 2-10 | 7-3 | 4-12 | R1 | OFF | OFF | OFF | 4-12 | OFF | OFF | R10 | OFF | 5-10 |  |  |  |  | 4-10 |  |  |  |  |  |  |  |  | OFF | 4-12 | OFF | R