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

Davinder Toor | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] April
8.30-1.30 |  | 8-2 | 6-12 | 9.30-3 | 9.30-2.30 |  |  |  |  | 6-11 | 6-2 | 7-3 | 4-12 | 5-11 | 2-10 | R
8.30-1.30 |  | 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 | 5-11 | 2-10 | R
8.30-1.30 |  | 8-12 |  | 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
8.30-1.30 | 5-11 | 8-12 |  |  | 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
 | 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
 | 5-11 |  |  |  |  |  |  |  |  |  |  | OFF | 4-12 | 5-11 | OFF | OFF
 |  |  | 4-10 |  |  |  |  |  |  |  |  | OFF | 4-12 | 5-11 | OFF | R
Mon | 6-2 | 6-2 | 6-2 | 6-2 | 7-3 | 7-3 | 7-3 | 7-3 | 2-10 | 2-10 | 3-11 | 3-11 | 3-11 | 4-12 | 4-12 | 4-12 | 4-12 |  |  |  | 17 early and late weeks
[NAME] | 6-2 | 6-2 | 6-2 | 6-2 | 7-3 | 7-3 | 7-3 | 7-3 | 2-10 | 2-10 | 3-11 | 3-11 | 3-11 | 4-12 | 4-12 | 4-12 | 4-12
Wed | 6-2 | 6-2 | 6-2 | 6-2 | 7-3 | 7-3 | 7-3 | 7-3 | 2-10 | 2-10 | 3-11 | 3-11 | 3-11 | 4-12 | 4-12 | 4-12 | 4-12
Thurs | 6-2 | 6-2 | 6-2 | 6-2 | 7-3 | 7-3 | 7-3 | 7-3 | 2-10 | 2-10 | 3-11 | 3-11 | 3-11 | 4-12 | 4-12 | 4-12 | 4-12
Fri | 6-2 | 6-2 | 6-2 | 6-2 | 7-3 | 7-3 | 7-3 | 7-3 | 2-10 | 2-10 | 3-11 | 3-11 | 3-11 | 4-12 | 4-12 | 4-12 | 4-12
Sat | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF
Sun | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF
Mon | 12-8 | 12-8 | 12-8 | OFF | 1-9 | 1-9 | 1-9 | OFF | OFF | OFF | OFF | OFF | 9-5 | 10-6 | 10-6 | 9-5 | 8-4 | OFF | 8-4 | 12-8 | R1 | R2 | R3 | R4 | R5 | R6 | R7 | R8 | R9 | R10 | 20 random weeks with weekends at the end
[NAME] | 12-8 | 12-8 | 12-8 | 12-8 | 1-9 | 1-9 | 1-9 | 9-5 | 9-5 | 10-6 | 10-6 | 8-4 | OFF | OFF | OFF | OFF | OFF | 8-4 | OFF | OFF | R1 | R2 | R3 | R4 | R5 | R6 | R7 | R8 | R9 | R10
Wed | OFF | OFF | OFF | 12-8 | OFF | OFF | OFF | 9-5 | 9-5 | 10-6 | 10-6 | 8-4 | OFF | 12-8 | 12-8 | OFF | OFF | 1-9 | 1-9 | 1-9 | R1 | R2 | R3 | R4 | R5 | R6 | R7 | R8 | R9 | R10 | 10 r weeks
Thurs | OFF | OFF | OFF | 12-8 | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | 8-4 | 12-8 | 12-8 | 10-6 | 10-6 | 1-9 | 1-9 | 1-9 | R1 | R2 | R3 | R4 | R5 | R6 | R7 | R8 | R9 | R10
Fri | 8-4 | 8-4 | 8-4 | OFF | 9-5 | 9-5 | 9-5 | 12-8 | 12-8 | 1-9 | 1-9 | 1-9 | 12-8 | OFF | OFF | 10-6 | 10-6 | OFF | OFF | OFF | R1 | R2 | R3 | R4 | R5 | R6 | R7 | R8 | R9 | R10
Sat | 6-2 | 6-2 | 6-2 | 6-2 | 7-3 | 7-3 | 7-3 | 3-11 | 3-11 | 4-12 | 4-12 | 4-12 | 4-12 | 8-4 | 8-4 | 8-4 | 8-4 | 12-8 | 2-10 | 2-10 | R1 | R2 | R3 | R4 | R5 | R6 | R7 | R8 | R9 | R10
Sun | 6-2 | 6-2 | 6-2 | 6-2 | 7-3 | 7-3 | 7-3 | 3-11 | 3-11 | 4-12 | 4-12 | 4-12 | 4-12 | 8-4 | 8-4 | 8-4 | 8-4 | 12-8 | 2-10 | 2-10 | R1 | R2 | R3 | R4 | R5 | R6 | R7 | R8 | R9 | R10
Mon | 8-4 | 8-4 | 8-4 | 8-4 | 8-4 | 8-4 | 9-5 | 9-5 | 9-5 | 9-5 | 9-5 | 10-6 | 10-6 | 10-6 | 10-6 | need to pick 11 of the days weeks to fill
[NAME] | 8-4 | 8-4 | 8-4 | 8-4 | 8-4 | 8-4 | 9-5 | 9-5 | 9-5 | 9-5 | 9-5 | 10-6 | 10-6 | 10-6 | 10-6
Wed | 8-4 | 8-4 | 8-4 | 8-4 | 8-4 | 8-4 | 9-5 | 9-5 | 9-5 | 9-5 | 9-5 | 10-6 | 10-6 | 10-6 | 10-6
Thurs | 8-4 | 8-4 | 8-4 | 8-4 | 8-4 | 8-4 | 9-5 | 9-5 | 9-5 | 9-5 | 9-5 | 10-6 | 10-6 | 10-6 | 10-6
Fri | 8-4 | 8-4 | 8-4 | 8-4 | 8-4 | 8-4 | 9-5 | 9-5 | 9-5 | 9-5 | 9-5 | 10-6 | 10-6 | 10-6 | 10-6
Sat | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF
Sun | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF