Spreadsheet: 34411d1231678992-how-do-i-automatically-highlight-cells-when-times-are-entered-in-worksheet-master_roster_month-of-january-2009-2-3-2-
Sheet: Week Starting 221208  

WEEK STARTING |  |  | 2008-12-22 00:00:00
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 9 | 9 | 9 | 9 | 8 | 7 | 8 | 8 | 7 | 7 | 7 | 5 | 5 | 4 | 4 | 2 | 2
MONDAY | START TIME | FINISH TIME | 2008-12-22 00:00:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00
MELINDA | 07:00:00 | 14:00:00 | 7 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
SULE | 07:00:00 | 14:30:00 | 7.499999999999998 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
JESSICA | 08:00:00 | 16:00:00 | 8 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
CATHY | 08:30:00 | 20:30:00 | 12 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
ASHLEE | 09:00:00 | 17:30:00 | 8.5 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
SAMANTHA | 09:30:00 | 18:00:00 | 8.5 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
CON | 12:30:00 | 19:30:00 | 6.999999999999999 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
RACHEL | 12:30:00 | 20:30:00 | 7.999999999999998 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
SKYE | 12:30:00 | 19:30:00 | 6.999999999999999 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 15:30:00 | 19:30:00 | 3.999999999999999 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
HEATHER | 07:00:00 | 09:00:00 | 2 | ANNECTO
SHELLEY | 20:30:00 | 01:00:00 | 4.5
HEATHER | 20:30:00 | 00:30:00 | 4
JODIE | 20:30:00 | 07:00:00 | 10.5
TOTAL HOURS |  |  | 98.5
 |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 7 | 7 | 7 | 7 | 7 | 9 | 9 | 9 | 9 | 7 | 6 | 6 | 6 | 5 | 5 | 5 | 5 | 4 | 3 | 3 | 0 | 0
TUESDAY | START TIME | FINISH TIME | 2008-12-23 00:00:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00
MELINDA | 07:00:00 | 14:00:00 | 7 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
SKYE | 07:00:00 | 14:00:00 | 7 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
SAM PAYET | 07:30:00 | 14:30:00 | 6.999999999999999 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
RACHEL | 08:00:00 | 16:00:00 | 8 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
MARK | 08:30:00 | 18:30:00 | 10 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
MERYEM | 09:00:00 | 18:00:00 | 9 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
DANIEL | 09:30:00 | 19:30:00 | 10 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
SAMANTHA | 12:30:00 | 19:30:00 | 6.999999999999999 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
JESSICA | 12:30:00 | 19:30:00 | 6.999999999999999 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
HEATHER | 07:00:00 | 09:00:00 | 2 | ANNECTO
HEATHER | 17:00:00 | 23:30:00 | 6.499999999999998 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ANNECTO STARTING AT 5PM FROM SUNBURY OFFICE
JODIE | 19:30:00 | 23:00:00 | 3.500000000000001
RENEA | 19:30:00 | 07:00:00 | 11.5
TOTAL HOURS |  |  | 95.5
 |  |  |  | 2 | 3 | 4 | 5 | 5 | 6 | 6 | 6 | 6 | 7 | 7 | 10 | 10 | 10 | 10 | 9 | 8 | 8 | 8 | 7 | 7 | 7 | 6 | 5 | 4 | 4 | 0 | 0
WEDNESDAY | START TIME | FINISH TIME | 2008-12-24 00:00:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00
MELINDA | 07:00:00 | 14:00:00 | 7 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
ASHLEE | 07:00:00 | 16:00:00 | 8.999999999999998 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
SKYE | 07:30:00 | 14:30:00 | 6.999999999999999 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
CON | 08:30:00 | 17:30:00 | 8.999999999999998 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
DANIEL | 08:30:00 | 18:30:00 | 10 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
SAM PAYET | 09:30:00 | 18:00:00 | 8.5 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 11:30:00 | 19:30:00 | 8 |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
RACHEL | 12:30:00 | 19:30:00 | 6.999999999999999 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
MERYEM | 12:30:00 | 19:30:00 | 6.999999999999999 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 12:30:00 | 19:30:00 | 6.999999999999999 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
HEATHER | 17:00:00 | 23:30:00 | 6.499999999999998 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ANNECTO STARTING AT 5PM FROM SUNBURY OFFICE
SHELLEY | 19:30:00 | 01:30:00 | 6
JODIE | 19:30:00 | 23:00:00 | 3.500000000000001
RENEA | 19:30:00 | 07:00:00 | 11.5
TOTAL HOURS |  |  | 107
 |  |  |  | 2 | 2 | 2 | 3 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 5 | 5 | 5 | 5 | 5 | 4 | 3 | 2 | 2 | 2 | 2 | 2 | 0 | 0
THURSDAY | START TIME | FINISH TIME | 2008-12-25 00:00:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00
SAM PAYET | 07:00:00 | 13:30:00 | 6.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 07:00:00 | 16:30:00 | 9.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 08:30:00 | 16:00:00 | 7.499999999999998 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
MERYEM | 09:00:00 | 17:00:00 | 8 | ANNECTO |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
SULE | 10:00:00 | 19:30:00 | 9.5 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
MARK | 13:30:00 | 19:30:00 | 6 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
HEATHER | 07:00:00 | 09:00:00 | 2 | ANNECTO
HEATHER | 17:00:00 | 23:30:00 | 6.499999999999998 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ANNECTO STARTING AT 5PM FROM SUNBURY OFFICE
SHELLEY | 19:30:00 | 23:30:00 | 3.999999999999999
RENEA | 19:30:00 | 07:00:00 | 11.5
TOTAL HOURS |  |  | 71
 |  |  |  | 2 | 2 | 2 | 3 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 4 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 0 | 0
FRIDAY | START TIME | FINISH TIME | 2008-12-26 00:00:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00
CON | 07:00:00 | 13:00:00 | 5.999999999999998 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 07:00:00 | 15:30:00 | 8.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
SKYE | 08:30:00 | 16:00:00 | 7.499999999999998 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
MERYEM | 09:00:00 | 17:00:00 | 8 | ANNECTO |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
DANIEL | 12:00:00 | 19:30:00 | 7.5 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
SULE | 13:30:00 | 19:30:00 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
HEATHER | 07:00:00 | 09:00:00 | 2 | ANNNECTO
HEATHER | 17:00:00 | 1900-01-01 00:00:00 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ANNECTO STARTING AT 5PM FROM SUNBURY OFFICE
JODIE | 19:30:00 | 01:00:00 | 5.5
RENEA | 19:30:00 | 08:00:00 | 12.5
TOTAL HOURS |  |  | 70.5
SATURDAY |  |  | 2008-12-27 00:00:00 |  |  | 2 | 2 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 1 | 1 | 1
 |  |  |  | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00
SULE | 08:00:00 | 13:00:00 | 5 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
MELINDA | 08:00:00 | 15:00:00 | 7 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
JESSICA | 09:00:00 | 17:00:00 | 8 | ANNECTO |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 09:30:00 | 19:00:00 | 9.5 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
MARK | 12:00:00 | 19:00:00 | 6.999999999999999 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
HEATHER | 07:00:00 | 09:00:00 | 2 | ANNECTO FROM HOME
HEATHER | 19:00:00 | 01:00:00 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ANNECTO STARTING AT 5PM FROM SUNBURY OFFICE
SHELLEY | 19:00:00 | 01:00:00 | 6
RENEA | 19:00:00 | 08:00:00 | 13
TOTAL HOURS |  |  | 63.5
SUNDAY |  |  | 2008-12-28 00:00:00 |  |  | 2 | 2 | 3 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 1 | 1
 |  |  |  | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00
[NAME] | 08:00:00 | 13:00:00 | 5 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 08:00:00 | 16:00:00 | 8 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
MERYEM | 09:00:00 | 17:00:00 | 8 | ANNECTO |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
MARK | 09:30:00 | 19:00:00 | 9.5 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
RACHEL | 12:00:00 | 19:00:00 | 6.999999999999999 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
HEATHER | 07:00:00 | 09:00:00 | 2 | ANNECTO FROM HOME
HEATHER | 17:00:00 | 23:30:00 | 6.499999999999998 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ANNECTO STARTING AT 5PM FROM SUNBURY OFFICE
SHELLEY | 20:00:00 | 23:30:00 | 3.499999999999998
JODIE | 19:00:00 | 07:00:00 | 12
TOTAL HOURS |  |  | 61.5
TOTAL HOURS
 |  |  | 567.5
ASHLEE |  |  | 17.5
BURAK |  |  | 0
CASSANDRA |  |  | 0
CON |  |  | 21.99999999999999
CATHY |  |  | 12
DANIEL |  |  | 27.5
HEATHER |  |  | 54.99999999999999
JESSICA |  |  | 23
JODIE |  |  | 35
[NAME] |  |  | 33
MARK |  |  | 32.5
[NAME] |  |  | 34
MELINDA |  |  | 28
MERYEM |  |  | 40
RACHEL |  |  | 30
SAMANTHA |  |  | 15.5
SAM P |  |  | 22
SHELLEY |  |  | 24
SKYE |  |  | 28.5
SULE |  |  | 28
RENEA |  |  | 60.00000000000001
TOTAL |  |  | 567.5
LESS NIGHT STAFF |  |  | 174
MAIN TOTAL |  |  | 393.5