Spreadsheet: 205952d1357946823-count-of-employees-at-any-given-time-count-of-employees-at-any-given-time-pcb-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | How Many Workers Total Between Hours
GROUP | Supervisors | Employees | Date Start | Time Start | Date End | Time End | Start | Finish
1 | 2 | 10 | 2013-01-11 00:00:00 | 14:00:00 | 2013-01-12 00:00:00 | 1900-01-01 00:00:00 | 2013-01-11 14:00:00 | 2013-01-12 00:00:00 | Between | Date: | 2013-01-11 00:00:00 | 2013-01-11 12:00:00 | Supervisors | Employees
2 | 1 | 9 | 2013-01-11 00:00:00 | 22:30:00 | 2013-01-12 00:00:00 | 08:30:00 | 2013-01-11 22:30:00 | 2013-01-12 08:30:00 |  | Time: | 12:00:00 |  | 3 | 19 | <-Max in time interval
3 | 2 | 10 | 2013-01-12 00:00:00 | 07:00:00 | 2013-01-12 00:00:00 | 17:00:00 | 2013-01-12 07:00:00 | 2013-01-12 17:00:00 | And | Date: | 2013-01-12 00:00:00 | 2013-01-12 16:00:00
4 | 1 | 6 | 2013-01-12 00:00:00 | 13:15:00 | 2013-01-12 00:00:00 | 23:15:00 | 2013-01-12 13:15:00 | 2013-01-12 23:15:00 |  | Time: | 16:00:00
 |  |  |  |  |  |  |  |  |  | Supervisors | Employees | TOTAL
 |  |  |  |  |  |  |  |  | 2013-01-11 14:00:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 14:15:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 14:30:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 14:45:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 15:00:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 15:15:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 15:30:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 15:45:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 16:00:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 16:15:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 16:30:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 16:45:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 17:00:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 17:15:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 17:30:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 17:45:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 18:00:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 18:15:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 18:30:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 18:45:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 19:00:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 19:15:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 19:30:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 19:45:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 20:00:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 20:15:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 20:30:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 20:45:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 21:00:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 21:15:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 21:30:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 21:45:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 22:00:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 22:15:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-11 22:30:00 | 3 | 19 | 22
 |  |  |  |  |  |  |  |  | 2013-01-11 22:45:00 | 3 | 19 | 22
 |  |  |  |  |  |  |  |  | 2013-01-11 23:00:00 | 3 | 19 | 22
 |  |  |  |  |  |  |  |  | 2013-01-11 23:15:00 | 3 | 19 | 22
 |  |  |  |  |  |  |  |  | 2013-01-11 23:30:00 | 3 | 19 | 22
 |  |  |  |  |  |  |  |  | 2013-01-11 23:45:00 | 3 | 19 | 22
 |  |  |  |  |  |  |  |  | 2013-01-12 00:00:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 00:15:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 00:30:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 00:45:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 01:00:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 01:15:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 01:30:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 01:45:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 02:00:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 02:15:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 02:30:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 02:45:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 03:00:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 03:15:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 03:30:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 03:45:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 04:00:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 04:15:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 04:30:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 04:45:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 05:00:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 05:15:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 05:30:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 05:45:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 06:00:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 06:15:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 06:30:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 06:45:00 | 1 | 9 | 10
 |  |  |  |  |  |  |  |  | 2013-01-12 07:00:00 | 3 | 19 | 22
 |  |  |  |  |  |  |  |  | 2013-01-12 07:15:00 | 3 | 19 | 22
 |  |  |  |  |  |  |  |  | 2013-01-12 07:30:00 | 3 | 19 | 22
 |  |  |  |  |  |  |  |  | 2013-01-12 07:45:00 | 3 | 19 | 22
 |  |  |  |  |  |  |  |  | 2013-01-12 08:00:00 | 3 | 19 | 22
 |  |  |  |  |  |  |  |  | 2013-01-12 08:15:00 | 3 | 19 | 22
 |  |  |  |  |  |  |  |  | 2013-01-12 08:30:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-12 08:45:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-12 09:00:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-12 09:15:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-12 09:30:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-12 09:45:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-12 10:00:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-12 10:15:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-12 10:30:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-12 10:45:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-12 11:00:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-12 11:15:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-12 11:30:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-12 11:45:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-12 12:00:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-12 12:15:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-12 12:30:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-12 12:45:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-12 13:00:00 | 2 | 10 | 12
 |  |  |  |  |  |  |  |  | 2013-01-12 13:15:00 | 3 | 16 | 19
 |  |  |  |  |  |  |  |  | 2013-01-12 13:30:00 | 3 | 16 | 19
 |  |  |  |  |  |  |  |  | 2013-01-12 13:45:00 | 3 | 16 | 19
 |  |  |  |  |  |  |  |  | 2013-01-12 14:00:00 | 3 | 16 | 19
 |  |  |  |  |  |  |  |  | 2013-01-12 14:15:00 | 3 | 16 | 19
 |  |  |  |  |  |  |  |  | 2013-01-12 14:30:00 | 3 | 16 | 19
 |  |  |  |  |  |  |  |  | 2013-01-12 14:45:00 | 3 | 16 | 19
 |  |  |  |  |  |  |  |  | 2013-01-12 15:00:00 | 3 | 16 | 19
 |  |  |  |  |  |  |  |  | 2013-01-12 15:15:00 | 3 | 16 | 19
 |  |  |  |  |  |  |  |  | 2013-01-12 15:30:00 | 3 | 16 | 19
 |  |  |  |  |  |  |  |  | 2013-01-12 15:45:00 | 3 | 16 | 19
 |  |  |  |  |  |  |  |  | 2013-01-12 16:00:00 | 3 | 16 | 19
 |  |  |  |  |  |  |  |  | 2013-01-12 16:15:00 | 3 | 16 | 19
 |  |  |  |  |  |  |  |  | 2013-01-12 16:30:00 | 3 | 16 | 19
 |  |  |  |  |  |  |  |  | 2013-01-12 16:45:00 | 3 | 16 | 19
 |  |  |  |  |  |  |  |  | 2013-01-12 17:00:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 17:15:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 17:30:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 17:45:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 18:00:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 18:15:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 18:30:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 18:45:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 19:00:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 19:15:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 19:30:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 19:45:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 20:00:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 20:15:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 20:30:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 20:45:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 21:00:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 21:15:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 21:30:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 21:45:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 22:00:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 22:15:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 22:30:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 22:45:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 23:00:00 | 1 | 6 | 7
 |  |  |  |  |  |  |  |  | 2013-01-12 23:15:00 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2013-01-12 23:30:00 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2013-01-12 23:45:00 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2013-01-13 00:00:00 | 0 | 0 | 0