Spreadsheet: 717308d1612562381-count-how-many-times-a-specific-time-is-in-a-range-roster1
Sheet: Sheet1

 |  | 2021-07-10 00:00:00 | Hours Between  Shifts | 2021-07-11 00:00:00 | Hours Between  Shifts | 2021-07-12 00:00:00 | Hours Between  Shifts | 2021-07-13 00:00:00 | Hours Between  Shifts | 2021-07-14 00:00:00 | Hours Between  Shifts | 2021-07-15 00:00:00 | Hours Between  Shifts | 2021-07-16 00:00:00 | Hours Between  Shifts | 2021-07-17 00:00:00 | Hours Between  Shifts | 2021-07-18 00:00:00 | Hours Between  Shifts | 2021-07-19 00:00:00 | Hours Between  Shifts | 2021-07-20 00:00:00 | Hours Between  Shifts | 2021-07-21 00:00:00
 |  | Sat |  | Sun |  | Mon |  | Tue |  | Wed |  | Thu |  | Fri |  | Sat |  | Sun |  | Mon |  | Tue |  | Wed
Emp 1 | S | 2021-07-10 09:00:00 |  | 2021-07-11 09:00:00 |  | 2021-07-12 06:00:00 |  | 2021-07-13 07:00:00 |  | 2021-07-14 07:00:00 |  | 2021-07-15 07:00:00 |  | 2021-07-16 07:00:00 |  | 2021-07-17 06:00:00 |  | 2021-07-18 06:00:00 |  | 2021-07-19 07:00:00 |  | 2021-07-20 06:00:00 |  | 2021-07-21 06:00:00
 | E | 2021-07-10 18:00:00 |  | 2021-07-11 15:00:00 |  | 2021-07-12 12:00:00 |  | 2021-07-13 15:00:00 |  | 2021-07-14 15:00:00 |  | 2021-07-15 15:00:00 |  | 2021-07-16 15:00:00 |  | 2021-07-17 16:00:00 |  | 2021-07-18 16:00:00 |  | 2021-07-19 15:00:00 |  | 2021-07-20 16:00:00 |  | 2021-07-21 16:00:00
Emp 2 | S | 2021-07-10 09:00:00 |  | 2021-07-11 09:00:00 |  | 2021-07-12 10:00:00 |  | 2021-07-13 10:00:00 |  | 2021-07-14 10:00:00 |  | 2021-07-15 10:00:00 |  | 2021-07-16 10:00:00 |  | 2021-07-17 15:00:00 |  | 2021-07-18 15:00:00 |  | 2021-07-19 10:00:00 |  | 2021-07-20 15:00:00 |  | 2021-07-21 15:00:00
 | E | 2021-07-10 18:00:00 |  | 2021-07-11 15:00:00 |  | 2021-07-12 17:00:00 |  | 2021-07-13 18:00:00 |  | 2021-07-14 18:00:00 |  | 2021-07-15 18:00:00 |  | 2021-07-16 18:00:00 |  | 2021-07-18 00:00:00 |  | 2021-07-19 00:00:00 |  | 2021-07-19 18:00:00 |  | 2021-07-21 00:00:00 |  | 2021-07-22 00:00:00
Emp 3 | S | 2021-07-10 09:00:00 |  | 2021-07-11 13:00:00 |  | 2021-07-12 14:00:00 |  | 2021-07-13 18:00:00 |  | 2021-07-14 18:00:00 |  | 2021-07-15 18:00:00 |  | 2021-07-16 18:00:00 |  | 2021-07-17 18:00:00 |  | 2021-07-18 23:00:00 |  | 2021-07-19 18:00:00 |  | 2021-07-20 23:00:00 |  | 2021-07-21 23:00:00
 | E | 2021-07-10 18:00:00 |  | 2021-07-11 19:00:00 |  | 2021-07-12 21:00:00 |  | 2021-07-13 01:00:00 |  | 2021-07-14 01:00:00 |  | 2021-07-15 01:00:00 |  | 2021-07-16 01:00:00 |  | 2021-07-17 01:00:00 |  | 2021-07-18 08:00:00 |  | 2021-07-19 01:00:00 |  | 2021-07-20 08:00:00 |  | 2021-07-21 08:00:00
Emp 4 | S | 2021-07-10 09:00:00 |  | 2021-07-11 09:00:00 |  | 2021-07-12 06:00:00 |  | 2021-07-13 07:00:00 |  | 2021-07-14 07:00:00 |  | 2021-07-15 07:00:00 |  | 2021-07-16 07:00:00 |  | 2021-07-17 06:00:00 |  | 2021-07-18 06:00:00 |  | 2021-07-19 07:00:00 |  | 2021-07-20 06:00:00 |  | 2021-07-21 06:00:00
 | E | 2021-07-10 18:00:00 |  | 2021-07-11 15:00:00 |  | 2021-07-12 13:00:00 |  | 2021-07-13 15:00:00 |  | 2021-07-14 15:00:00 |  | 2021-07-15 15:00:00 |  | 2021-07-16 15:00:00 |  | 2021-07-17 16:00:00 |  | 2021-07-18 16:00:00 |  | 2021-07-19 15:00:00 |  | 2021-07-20 16:00:00 |  | 2021-07-21 16:00:00
Emp 5 | S | 2021-07-10 09:00:00 |  | 2021-07-11 09:00:00 |  | 2021-07-12 06:00:00 |  | 2021-07-13 08:00:00 |  | 2021-07-14 08:00:00 |  | 2021-07-15 08:00:00 |  | 2021-07-16 08:00:00 |  | 2021-07-17 06:00:00 |  | 2021-07-18 06:00:00 |  | 2021-07-19 08:00:00 |  | 2021-07-20 06:00:00 |  | 2021-07-21 06:00:00
 | E | 2021-07-10 18:00:00 |  | 2021-07-11 15:00:00 |  | 2021-07-12 13:00:00 |  | 2021-07-13 16:00:00 |  | 2021-07-14 16:00:00 |  | 2021-07-15 16:00:00 |  | 2021-07-16 16:00:00 |  | 2021-07-17 16:00:00 |  | 2021-07-18 16:00:00 |  | 2021-07-19 16:00:00 |  | 2021-07-20 16:00:00 |  | 2021-07-21 16:00:00
Emp 6 | S | 2021-07-10 09:00:00 |  | 2021-07-11 09:00:00 |  | 2021-07-12 09:00:00 |  | 2021-07-13 10:00:00 |  | 2021-07-14 10:00:00 |  | 2021-07-15 10:00:00 |  | 2021-07-16 10:00:00 |  | 2021-07-17 14:00:00 |  | 2021-07-18 14:00:00 |  | 2021-07-19 10:00:00 |  | 2021-07-20 14:00:00 |  | 2021-07-21 14:00:00
 | E | 2021-07-10 18:00:00 |  | 2021-07-11 15:00:00 |  | 2021-07-12 16:00:00 |  | 2021-07-13 18:00:00 |  | 2021-07-14 18:00:00 |  | 2021-07-15 18:00:00 |  | 2021-07-16 18:00:00 |  | 2021-07-18 00:00:00 |  | 2021-07-19 00:00:00 |  | 2021-07-19 18:00:00 |  | 2021-07-21 00:00:00 |  | 2021-07-22 00:00:00
Emp 7 | S | 2021-07-10 09:00:00 |  | 2021-07-11 13:00:00 |  | 2021-07-12 14:00:00 |  | 2021-07-13 13:00:00 |  | 2021-07-14 13:00:00 |  | 2021-07-15 13:00:00 |  | 2021-07-16 13:00:00 |  | 2021-07-17 23:00:00 |  | 2021-07-18 23:00:00 |  | 2021-07-19 23:00:00 |  | 2021-07-20 23:00:00 |  | 2021-07-21 23:00:00
 | E | 2021-07-10 18:00:00 |  | 2021-07-11 19:00:00 |  | 2021-07-12 21:00:00 |  | 2021-07-13 21:00:00 |  | 2021-07-14 21:00:00 |  | 2021-07-15 21:00:00 |  | 2021-07-16 21:00:00 |  | 2021-07-17 08:00:00 |  | 2021-07-18 08:00:00 |  | 2021-07-19 08:00:00 |  | 2021-07-20 08:00:00 |  | 2021-07-21 08:00:00
Emp 8 | S | 2021-07-10 09:00:00 |  | 2021-07-11 09:00:00 |  | 2021-07-12 06:00:00 |  | 2021-07-13 07:00:00 |  | 2021-07-14 07:00:00 |  | 2021-07-15 07:00:00 |  | 2021-07-16 07:00:00 |  | 2021-07-17 06:00:00 |  | 2021-07-18 06:00:00 |  | 2021-07-19 07:00:00 |  | 2021-07-20 06:00:00 |  | 2021-07-21 06:00:00
 | E | 2021-07-10 18:00:00 |  | 2021-07-11 15:00:00 |  | 2021-07-12 14:00:00 |  | 2021-07-13 15:00:00 |  | 2021-07-14 15:00:00 |  | 2021-07-15 15:00:00 |  | 2021-07-16 15:00:00 |  | 2021-07-17 16:00:00 |  | 2021-07-18 16:00:00 |  | 2021-07-19 15:00:00 |  | 2021-07-20 16:00:00 |  | 2021-07-21 16:00:00
Emp 9 | S | 2021-07-10 09:00:00 |  | 2021-07-11 13:00:00 |  | 2021-07-12 13:00:00 |  | 2021-07-13 12:00:00 |  | 2021-07-14 12:00:00 |  | 2021-07-15 12:00:00 |  | 2021-07-16 12:00:00 |  | 2021-07-17 13:00:00 |  | 2021-07-18 13:00:00 |  | 2021-07-19 13:00:00 |  | 2021-07-20 13:00:00 |  | 2021-07-21 13:00:00
 | E | 2021-07-10 18:00:00 |  | 2021-07-11 19:00:00 |  | 2021-07-12 21:00:00 |  | 2021-07-13 20:00:00 |  | 2021-07-14 20:00:00 |  | 2021-07-15 20:00:00 |  | 2021-07-16 20:00:00 |  | 2021-07-17 23:00:00 |  | 2021-07-18 23:00:00 |  | 2021-07-19 23:00:00 |  | 2021-07-20 23:00:00 |  | 2021-07-21 23:00:00
Emp 10 | S | 2021-07-10 09:00:00 |  | 2021-07-11 09:00:00 |  | 2021-07-12 07:00:00 |  | 2021-07-13 08:00:00 |  | 2021-07-14 08:00:00 |  | 2021-07-15 08:00:00 |  | 2021-07-16 08:00:00 |  | 2021-07-17 07:00:00 |  | 2021-07-18 07:00:00 |  | 2021-07-19 08:00:00 |  | 2021-07-20 07:00:00 |  | 2021-07-21 07:00:00
 | E | 2021-07-10 18:00:00 |  | 2021-07-11 15:00:00 |  | 2021-07-12 15:00:00 |  | 2021-07-13 16:00:00 |  | 2021-07-14 16:00:00 |  | 2021-07-15 16:00:00 |  | 2021-07-16 16:00:00 |  | 2021-07-17 17:00:00 |  | 2021-07-18 17:00:00 |  | 2021-07-19 16:00:00 |  | 2021-07-20 17:00:00 |  | 2021-07-21 17:00:00
Emp 11 | S | 2021-07-10 09:00:00 |  | 2021-07-11 09:00:00 |  | 2021-07-12 07:00:00 |  | 2021-07-13 07:00:00 |  | 2021-07-14 07:00:00 |  | 2021-07-15 07:00:00 |  | 2021-07-16 07:00:00 |  | 2021-07-17 07:00:00 |  | 2021-07-18 07:00:00 |  | 2021-07-19 07:00:00 |  | 2021-07-20 07:00:00 |  | 2021-07-21 07:00:00
 | E | 2021-07-10 18:00:00 |  | 2021-07-11 15:00:00 |  | 2021-07-12 15:00:00 |  | 2021-07-13 15:00:00 |  | 2021-07-14 15:00:00 |  | 2021-07-15 15:00:00 |  | 2021-07-16 15:00:00 |  | 2021-07-17 17:00:00 |  | 2021-07-18 17:00:00 |  | 2021-07-19 15:00:00 |  | 2021-07-20 17:00:00 |  | 2021-07-21 17:00:00
Emp 12 | S | 2021-07-10 09:00:00 |  | 2021-07-11 13:00:00 |  | 2021-07-12 14:00:00 |  | 2021-07-13 13:00:00 |  | 2021-07-14 13:00:00 |  | 2021-07-15 13:00:00 |  | 2021-07-16 13:00:00 |  | 2021-07-17 15:00:00 |  | 2021-07-18 15:00:00 |  | 2021-07-19 13:00:00 |  | 2021-07-20 15:00:00 |  | 2021-07-21 15:00:00
 | E | 2021-07-10 18:00:00 |  | 2021-07-11 19:00:00 |  | 2021-07-12 21:00:00 |  | 2021-07-13 21:00:00 |  | 2021-07-14 21:00:00 |  | 2021-07-15 21:00:00 |  | 2021-07-16 21:00:00 |  | 2021-07-17 01:00:00 |  | 2021-07-18 01:00:00 |  | 2021-07-19 21:00:00 |  | 2021-07-20 01:00:00 |  | 2021-07-21 01:00:00
Emp 13 | S | 2021-07-10 09:00:00 |  | 2021-07-11 13:00:00 |  | 2021-07-12 14:00:00 |  | 2021-07-13 12:00:00 |  | 2021-07-14 12:00:00 |  | 2021-07-15 12:00:00 |  | 2021-07-16 12:00:00 |  | 2021-07-17 15:00:00 |  | 2021-07-18 15:00:00 |  | 2021-07-19 12:00:00 |  | 2021-07-20 15:00:00 |  | 2021-07-21 15:00:00
 | E | 2021-07-10 18:00:00 |  | 2021-07-11 19:00:00 |  | 2021-07-12 21:00:00 |  | 2021-07-13 20:00:00 |  | 2021-07-14 20:00:00 |  | 2021-07-15 20:00:00 |  | 2021-07-16 20:00:00 |  | 2021-07-17 01:00:00 |  | 2021-07-18 01:00:00 |  | 2021-07-19 20:00:00 |  | 2021-07-20 01:00:00 |  | 2021-07-21 01:00:00
Emp 14 | S | 2021-07-10 09:00:00 |  | 2021-07-11 09:00:00 |  | 2021-07-12 07:00:00 |  | 2021-07-13 07:00:00 |  | 2021-07-14 07:00:00 |  | 2021-07-15 07:00:00 |  | 2021-07-16 07:00:00 |  | 2021-07-17 23:00:00 |  | 2021-07-18 23:00:00 |  | 2021-07-19 07:00:00 |  | 2021-07-20 23:00:00 |  | 2021-07-21 23:00:00
 | E | 2021-07-10 18:00:00 |  | 2021-07-11 15:00:00 |  | 2021-07-12 15:00:00 |  | 2021-07-13 15:00:00 |  | 2021-07-14 15:00:00 |  | 2021-07-15 15:00:00 |  | 2021-07-16 15:00:00 |  | 2021-07-17 08:00:00 |  | 2021-07-18 08:00:00 |  | 2021-07-19 15:00:00 |  | 2021-07-20 08:00:00 |  | 2021-07-21 08:00:00
Emp 15 | S | 2021-07-10 09:00:00 |  | 2021-07-11 09:00:00 |  | 2021-07-12 07:00:00 |  | 2021-07-13 10:00:00 |  | 2021-07-14 10:00:00 |  | 2021-07-15 10:00:00 |  | 2021-07-16 10:00:00 |  | 2021-07-17 07:00:00 |  | 2021-07-18 07:00:00 |  | 2021-07-19 07:00:00 |  | 2021-07-20 07:00:00 |  | 2021-07-21 07:00:00
 | E | 2021-07-10 18:00:00 |  | 2021-07-11 15:00:00 |  | 2021-07-12 15:00:00 |  | 2021-07-13 18:00:00 |  | 2021-07-14 18:00:00 |  | 2021-07-15 18:00:00 |  | 2021-07-16 18:00:00 |  | 2021-07-17 17:00:00 |  | 2021-07-18 17:00:00 |  | 2021-07-19 17:00:00 |  | 2021-07-20 17:00:00 |  | 2021-07-21 17:00:00
Emp 16 | S | 2021-07-10 09:00:00 |  | 2021-07-11 09:00:00 |  | 2021-07-12 11:00:00 |  | 2021-07-13 09:00:00 |  | 2021-07-14 09:00:00 |  | 2021-07-15 09:00:00 |  | 2021-07-16 09:00:00 |  | 2021-07-17 07:00:00 |  | 2021-07-18 07:00:00 |  | 2021-07-19 09:00:00 |  | 2021-07-20 07:00:00 |  | 2021-07-21 07:00:00
 | E | 2021-07-10 18:00:00 |  | 2021-07-11 15:00:00 |  | 2021-07-12 18:00:00 |  | 2021-07-13 17:00:00 |  | 2021-07-14 17:00:00 |  | 2021-07-15 17:00:00 |  | 2021-07-16 17:00:00 |  | 2021-07-17 17:00:00 |  | 2021-07-18 17:00:00 |  | 2021-07-19 17:00:00 |  | 2021-07-20 17:00:00 |  | 2021-07-21 17:00:00
Emp 17 | S | 2021-07-10 09:00:00 |  | 2021-07-11 13:00:00 |  | 2021-07-12 14:00:00 |  | 2021-07-13 18:00:00 |  | 2021-07-14 18:00:00 |  | 2021-07-15 18:00:00 |  | 2021-07-16 18:00:00 |  | 2021-07-17 12:00:00 |  | 2021-07-18 12:00:00 |  | 2021-07-19 12:00:00 |  | 2021-07-20 12:00:00 |  | 2021-07-21 12:00:00
 | E | 2021-07-10 18:00:00 |  | 2021-07-11 19:00:00 |  | 2021-07-12 21:00:00 |  | 2021-07-13 01:00:00 |  | 2021-07-14 01:00:00 |  | 2021-07-15 01:00:00 |  | 2021-07-16 01:00:00 |  | 2021-07-17 22:00:00 |  | 2021-07-18 22:00:00 |  | 2021-07-19 22:00:00 |  | 2021-07-20 22:00:00 |  | 2021-07-21 22:00:00
Emp 18 | S | 2021-07-10 09:00:00 |  | 2021-07-11 13:00:00 |  | 2021-07-12 14:00:00 |  | 2021-07-13 13:00:00 |  | 2021-07-14 13:00:00 |  | 2021-07-15 13:00:00 |  | 2021-07-16 13:00:00 |  | 2021-07-17 13:00:00 |  | 2021-07-18 13:00:00 |  | 2021-07-19 13:00:00 |  | 2021-07-20 13:00:00 |  | 2021-07-21 14:00:00
 | E | 2021-07-10 18:00:00 |  | 2021-07-11 19:00:00 |  | 2021-07-12 21:00:00 |  | 2021-07-13 21:00:00 |  | 2021-07-14 21:00:00 |  | 2021-07-15 21:00:00 |  | 2021-07-16 21:00:00 |  | 2021-07-17 23:00:00 |  | 2021-07-18 23:00:00 |  | 2021-07-19 23:00:00 |  | 2021-07-20 23:00:00 |  | 2021-07-22 00:00:00
 |  | 2021-07-10 00:00:00 |  | 2021-07-11 00:00:00 |  | 2021-07-12 00:00:00 |  | 2021-07-13 00:00:00 |  | 2021-07-14 00:00:00 |  | 2021-07-15 00:00:00 |  | 2021-07-16 00:00:00 |  | 2021-07-17 00:00:00 |  | 2021-07-18 00:00:00 |  | 2021-07-19 00:00:00 |  | 2021-07-20 00:00:00 |  | 2021-07-21 00:00:00
Shift Starts |  | Sat |  | Sun |  | Mon |  | Tue |  | Wed |  | Thu |  | Fri |  | Sat |  | Sun |  | Mon |  | Tue |  | Wed
05:00:00
06:00:00
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
14:00:00
15:00:00
18:00:00
23:00:00
1900-01-01 00:00:00
Total Shifts