Spreadsheet: 92044d1291718479-converting-hours-to-number-value-schedule-help
Sheet: Sheet1

OCT | MONDAY |  |  | TUESDAY |  |  | WEDNESDAY |  |  | THURSDAY |  |  | FRIDAY |  |  | SATURDAY |  |  | SUNDAY
 | 2010-12-13 00:00:00 |  |  | 2010-12-14 00:00:00 |  |  | 2010-12-15 00:00:00 |  |  | 2010-12-16 00:00:00 |  |  | 2010-12-17 00:00:00 |  |  | 2010-12-18 00:00:00 |  |  | 2010-12-19 00:00:00
 | IN | OUT |  | IN | OUT |  | IN | OUT |  | IN | OUT |  | IN | OUT |  | IN | OUT |  | IN | OUT
MGMT
jeannine | 05:00:00 | 15:00:00 | 10 | 09:00:00 | 19:00:00 | 10 |  |  | 0 | 09:00:00 | 19:00:00 | 10 | 09:00:00 | 19:00:00 | 10 | 09:00:00 | 19:00:00 | 10
tj | 06:00:00 | 14:00:00 | 8 | 07:00:00 | 14:00:00 | 7 | 07:00:00 | 10:00:00 | 3 | 07:00:00 | 14:00:00 | 7 | 07:00:00 | 14:00:00 | 7 | 07:00:00 | 13:00:00 | 5.999999999999998
sandi |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
[NAME] | 10:00:00 | 18:00:00 | 8 | 09:00:00 | 19:00:00 | 10 | 09:00:00 | 19:00:00 | 10 |  |  | 0 |  |  | 0 |  |  | 0
Shyla | 12:00:00 | 17:00:00 | 5.000000000000001 | 17:00:00 | 03:00:00 | 10 | 17:00:00 | 03:00:00 | 10 |  |  | 0 |  |  | 0 |  |  | 0 | 07:00:00 | 17:00:00
[NAME] | 17:00:00 | 03:00:00 | 10 |  |  | 0 |  |  | 0 | 17:00:00 | 03:00:00 | 10 | 17:00:00 | 03:00:00 | 10 |  |  | 0 | 17:00:00 | 03:00:00
 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
DAY CREW |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
[NAME] | 11:00:00 | 19:00:00 | 8 |  |  | 0 | 11:00:00 | 19:00:00 | 8 | 11:00:00 | 18:00:00 | 7 | 11:00:00 | 19:00:00 | 8 |  |  | 0 | 07:00:00 | 15:00:00
[NAME] | 07:00:00 | 14:00:00 | 7 | 07:00:00 | 14:00:00 | 7 | 07:00:00 | 14:00:00 | 7 | 07:00:00 | 14:00:00 | 7 | 07:00:00 | 14:00:00 | 7 | 07:00:00 | 11:00:00 | 3.999999999999999
shane | 06:00:00 | 14:00:00 | 8 | 07:00:00 | 14:00:00 | 7 | 07:00:00 | 14:00:00 | 7 | 07:00:00 | 14:00:00 | 7 | 06:00:00 | 14:00:00 | 8 |  |  | 0
luigi | 07:00:00 | 14:00:00 | 7 | 11:00:00 | 17:00:00 | 6.000000000000002 | 11:00:00 | 17:00:00 | 6.000000000000002 | 11:00:00 | 19:00:00 | 8 | 07:00:00 | 14:00:00 | 7 | 07:00:00 | 14:00:00 | 7
helena | 11:00:00 | 19:00:00 | 8 | 11:00:00 | 19:00:00 | 8 |  |  | 0 | 11:00:00 | 19:00:00 | 8 | 11:00:00 | 19:00:00 | 8 | 11:00:00 | 19:00:00 | 8
Davion |  |  | 0 | 11:00:00 | 19:00:00 | 8 | 11:00:00 | 20:00:00 | 9.000000000000002 | 14:00:00 | 22:00:00 | 7.999999999999998 | 11:00:00 | 18:00:00 | 7 |  |  | 0 | 11:00:00 | 19:00:00
mercedes |  |  | 0 | 11:00:00 | 17:00:00 | 6.000000000000002 | 11:00:00 | 19:00:00 | 8 | 11:00:00 | 18:00:00 | 7 |  |  | 0 |  |  | 0
sophia | 14:00:00 | 20:00:00 | 6 |  |  | 0 | 11:00:00 | 17:00:00 | 6.000000000000002 | 11:00:00 | 17:00:00 | 6.000000000000002 |  |  | 0 | 11:00:00 | 17:00:00 | 6.000000000000002 | 07:00:00 | 17:00:00
shamarra |  |  | 0 |  |  | 0 |  |  | 0 | 11:00:00 | 15:00:00 | 4 | 11:00:00 | 17:00:00 | 6.000000000000002 | 11:00:00 | 16:00:00 | 5
 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
NIGHT CREW |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
blanca * | 17:00:00 | 23:00:00 | 6 | 17:00:00 | 23:00:00 | 6 |  |  | 0 |  |  | 0 | 18:00:00 | 23:00:00 | 5.000000000000001 |  |  | 0
[NAME] |  |  | 0 | 19:00:00 | 03:00:00 | 8 | 19:00:00 | 03:00:00 | 8 | 19:00:00 | 03:00:00 | 8 | 19:00:00 | 03:00:00 | 8 |  |  | 0 | 19:00:00 | 03:00:00
penny |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 17:00:00 | 23:00:00 | 6 | 15:00:00 | 20:00:00
[NAME] |  |  | 0 | 17:00:00 | 23:00:00 | 6 |  |  | 0 | 19:00:00 | 1900-01-01 00:00:00 | 5.000000000000001 | 18:00:00 | 22:00:00 | 3.999999999999999 | 11:00:00 | 19:00:00 | 8 | 17:00:00 | 23:00:00
krystle | 17:00:00 | 20:00:00 | 3 | 17:00:00 | 20:00:00 | 3 |  |  | 0 | 18:00:00 | 22:00:00 | 3.999999999999999 |  |  | 0 |  |  | 0
debra | 19:00:00 | 03:00:00 | 8 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 19:00:00 | 03:00:00 | 8 | 19:00:00 | 03:00:00
alyssa | 19:00:00 | 03:00:00 | 8 | 19:00:00 | 23:00:00 | 4.000000000000002 |  |  | 0 | 19:00:00 | 03:00:00 | 8 | 19:00:00 | 03:00:00 | 8 |  |  | 0 | 19:00:00 | 1900-01-01 00:00:00
carolyn |  |  | 0 |  |  | 0 | 19:00:00 | 1900-01-01 00:00:00 | 5.000000000000001 |  |  | 0 |  |  | 0 | 18:00:00 | 22:00:00 | 3.999999999999999
mateenah |  |  | 0 |  |  | 0 | 17:00:00 | 19:00:00 | 1.999999999999998 |  |  | 0 | 17:00:00 | 20:00:00 | 3 |  |  | 0
[NAME] |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
[NAME] |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 11:00:00 | 14:30:00 | 3.5 | 12:00:00 | 15:00:00
 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
MINORS |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
[NAME] |  |  | 0 |  |  | 0 |  |  | 0 | 17:00:00 | 22:00:00 | 4.999999999999998 | 18:00:00 | 22:00:00 | 3.999999999999999 |  |  | 0
[NAME] |  |  | 0 | 17:00:00 | 22:00:00 | 4.999999999999998 | 17:00:00 | 22:00:00 | 4.999999999999998 |  |  | 0 |  |  | 0 |  |  | 0 | 11:00:00 | 16:00:00
kyia |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 11:00:00 | 16:00:00 | 5 | 11:00:00 | 16:00:00
katlin |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
[NAME] | 17:00:00 | 22:00:00 | 4.999999999999998 |  |  | 0 | 17:00:00 | 22:00:00 | 4.999999999999998 |  |  | 0 |  |  | 0 |  |  | 0 | 17:00:00 | 22:00:00
 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0