Spreadsheet: 470077d1468332048-formula-to-count-employees-on-schedule-over-24-hour-period-copy-of-week-ending-06-26-16-time-ranges-spanning-midnight-
Sheet: Master

 |  |  | EMPLOYEE SCHEDULE
 | 2016-06-20 00:00:00 |  | 2016-06-21 00:00:00 |  | 2016-06-22 00:00:00 |  | 2016-06-23 00:00:00 |  | 2016-06-24 00:00:00 |  | 2016-06-25 00:00:00 |  | 2016-06-26 00:00:00 |  | 2016-05-09 00:00:00
 | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY |  | SUNDAY |  | INITIAL |  | Monday
 | START | END | START | END | START | END | START | END | START | END | START | END | START | END |  |  | 00:00:00 | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 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 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00
Employee #1 | X | X | X | X | 10:00:00 | 18:00:00 | 10:00:00 | 18:00:00 | 10:00:00 | 18:00:00 | 10:00:00 | 18:00:00 | 10:00:00 | 18:00:00
Employee #2 | 12:00:00 | 20:00:00 | SM | SM | X | X | X | X | SM | SM | SM | SM | 16:00:00 | 00:00:00
Employee #3 | 14:00:00 | 22:00:00 | 12:00:00 | 8:00PM | X | X | X | X | 14:00:00 | 22:00:00 | 14:00:00 | 22:00:00 | 14:00:00 | 22:00:00
Employee #4 | X | X | 08:00:00 | 04:00:00 | 18:00:00 | 04:00:00 | 18:00:00 | 04:00:00 | 20:00:00 | 04:00:00 | 20:00:00 | 04:00:00 | X | X
Employee #5 | X | X | X | X | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00
Employee #6 | 06:00:00 | 14:00:00 | X | X | X | X | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00
Employee #7 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | X | X | X | X | 08:00:00 | 16:00:00 | 08:00:00 | 16:00:00 | 08:00:00 | 16:00:00
Employee #8 | 08:00:00 | 16:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 08:00:00 | 16:00:00 | X | X | X | X | X | X
Employee #9 | X | X | X | X | 08:00:00 | 16:00:00 | 10:00:00 | 18:00:00 | 10:00:00 | 18:00:00 | 10:00:00 | 18:00:00 | 08:00:00 | 16:00:00
Employee #10 | 10:00:00 | 18:00:00 | X | X | X | X | 12:00:00 | 20:00:00 | 12:00:00 | 20:00:00 | 10:00:00 | 18:00:00 | 10:00:00 | 18:00:00
Employee #11 | 12:00:00 | 20:00:00 | 08:00:00 | 16:00:00 | 10:00:00 | 18:00:00 | X | X | X | X | 12:00:00 | 20:00:00 | 12:00:00 | 20:00:00
Employee #12 | 14:00:00 | 22:00:00 | 10:00:00 | 18:00:00 | X | X | X | X | 12:00:00 | 20:00:00 | 12:00:00 | 20:00:00 | 12:00:00 | 20:00:00
Employee #13 | X | X | 14:00:00 | 22:00:00 | 14:00:00 | 22:00:00 | 14:00:00 | 22:00:00 | 14:00:00 | 22:00:00 | 14:00:00 | 22:00:00 | X | X
Employee #14 | X | X | X | X | 14:00:00 | 22:00:00 | 14:00:00 | 22:00:00 | 14:00:00 | 22:00:00 | 14:00:00 | 22:00:00 | 14:00:00 | 22:00:00
Employee #15 | 16:00:00 | 00:00:00 | X | X | X | X | 16:00:00 | 00:00:00 | 16:00:00 | 00:00:00 | 16:00:00 | 00:00:00 | 14:00:00 | 22:00:00
Employee #16 | 18:00:00 | 02:00:00 | 18:00:00 | 02:00:00 | X | X | X | X | 18:00:00 | 02:00:00 | 18:00:00 | 02:00:00 | 18:00:00 | 02:00:00
Employee #17 | X | X | X | X | 20:00:00 | 04:00:00 | 22:00:00 | 06:00:00 | 20:00:00 | 04:00:00 | 20:00:00 | 04:00:00 | 22:00:00 | 06:00:00
Employee #18 | X | X | X | X | 22:00:00 | 06:00:00 | 20:00:00 | 04:00:00 | 22:00:00 | 06:00:00 | 22:00:00 | 06:00:00 | 20:00:00 | 04:00:00
Employee #19 | X | X | 12:00:00 | 18:00:00 | X | X | X | X | X | X | 11:00:00 | 17:00:00 | 12:00:00 | 18:00:00
Employee #20 | X | X | 14:00:00 | 20:00:00 | 14:00:00 | 20:00:00 | X | X | X | X | 16:00:00 | 22:00:00 | 14:00:00 | 20:00:00
Employee #21 | X | X | 14:00:00 | 22:00:00 | 12:00:00 | 20:00:00 | X | X | 16:00:00 | 00:00:00 | 16:00:00 | 22:00:00 | X | X
Employee #22 | X | X | X | X | 18:00:00 | 00:00:00 | X | X | 18:00:00 | 02:00:00 | 18:00:00 | 02:00:00 | 14:00:00 | 22:00:00
Employee #23 | 22:00:00 | 02:00:00 | 22:00:00 | 06:00:00 | X | X | 18:00:00 | 02:00:00 | X | X | X | X | 16:00:00 | 22:00:00
Employee #24 | 20:00:00 | 04:00:00 | X | X | 22:00:00 | 06:00:00 | 22:00:00 | 06:00:00 | 20:00:00 | 02:00:00 | X | X | X | X
Employee #25 | X | X | 20:00:00 | 04:00:00 | X | X | X | X | 22:00:00 | 06:00:00 | 22:00:00 | 06:00:00 | 20:00:00 | 02:00:00
Expected Buses | 7 Lines |  | 6 Lines |  | 5 Lines |  | 7 Lines |  | 7 Lines |  | 9 Lines |  | 7 Lines
 | 2 Charters |  | 0 Charters |  | 0 Charters |  | 0 Charters |  | 0 Charters |  | 0 Charters |  | 0 Charters
 |  |  | EMPLOYEE COUNT CHART
06:00:00
08:00:00
10:00:00
12:00:00
14:00:00
16:00:00
18:00:00
20:00:00
22:00:00
00:00:00
02:00:00
04:00:00