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  271008 

WEEK STARTING |  |  | 2008-10-27 00:00:00
 |  |  |  | 2 | 3 | 4 | 6 | 8 | 8 | 8 | 9 | 8 | 9 | 9 | 8 | 8 | 8 | 8 | 8 | 7 | 7 | 6 | 7 | 7 | 7 | 7 | 5 | 5 | 4 | 3 | 2
MONDAY | START TIME | FINISH TIME | 2008-10-27 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
STEPHANIE | 07:00:00 | 10:30:00 | 3.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 07:00:00 | 14:30:00 | 7.499999999999998 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
RACHEL | 07:30:00 | 15:30:00 | 8 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
MERYEM | 08:00:00 | 12:00:00 | 4 |  |  | 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
SAM PAYET | 08:30:00 | 18:00:00 | 9.5 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
DANIEL | 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
MARK | 09:00:00 | 19:00:00 | 10 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
SAMANTHA | 10:30:00 | 20:00:00 | 9.5 |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
CON | 11:30:00 | 19:30:00 | 8 |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
MELINDA | 17:00:00 | 21:00:00 | 3.999999999999999 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
TOTAL HOURS |  |  | 85
 |  |  |  | 2 | 3 | 5 | 5 | 7 | 7 | 7 | 8 | 8 | 8 | 8 | 8 | 8 | 7 | 7 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 7 | 5 | 5 | 5 | 3 | 2
TUESDAY | START TIME | FINISH TIME | 2008-10-28 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
ASHLEE | 07:00:00 | 12:30:00 | 5.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
RACHEL | 07:00:00 | 14:30:00 | 7.499999999999998 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
MELINDA | 07:30:00 | 17: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 | 08:00:00 | 13:00:00 | 5 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
MERYEM | 08:00:00 | 20:30:00 | 12.5 |  |  | 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 | 1
CON | 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
STEPHANIE | 09:00:00 | 19:30:00 | 10.5 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
SAMANTHA | 10:30:00 | 19:30:00 | 9 |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
JESSICA | 13:00:00 | 18:00:00 | 5.000000000000001 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 15:00:00 | 20:00:00 | 5.000000000000001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
DANIEL | 16:30:00 | 20:30:00 | 3.999999999999999 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
TOTAL HOURS |  |  | 83
 |  |  |  | 2 | 3 | 4 | 6 | 7.708333333333334 | 8 | 8 | 8 | 8 | 8 | 8 | 7 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 5 | 4 | 3 | 3 | 2
WEDNESDAY | START TIME | FINISH TIME | 2008-10-29 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 | 12:00:00 | 5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
SAM PAYET | 07:00:00 | 18:00:00 | 11 | 1 | 1 | 1 | 1 | 0.7083333333333334 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
STEPHANIE | 07:30:00 | 15:00:00 | 7.5 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
MERYEM | 08:00:00 | 17:30:00 | 9.5 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
CON | 08:30:00 | 18:00:00 | 9.5 |  |  |  | 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
ASHLEE | 09:00:00 | 19:00:00 | 10 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
SAMANTHA | 10:30:00 | 14:30:00 | 3.999999999999999 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
JESSICA | 13:00:00 | 20:30:00 | 7.5 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
RACHEL | 15:00:00 | 20:00:00 | 5.000000000000001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 15:30:00 | 20:30:00 | 4.999999999999998 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
TOTAL HOURS |  |  | 84
 |  |  |  | 2 | 3 | 5 | 6 | 6 | 7 | 7 | 8 | 8 | 8 | 8 | 7 | 8 | 8 | 8 | 8 | 8 | 7 | 7 | 7 | 8 | 8 | 5 | 5 | 5 | 4 | 3 | 2
THURSDAY | START TIME | FINISH TIME | 2008-10-30 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
ASHLEE | 07:00:00 | 12:00:00 | 5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
RACHEL | 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
MELINDA | 07:30:00 | 16:00:00 | 8.5 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
CASSANDRA | 08:00:00 | 17:30:00 | 9.5 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
STEPHANIE | 08:00:00 | 17: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 | 17:30:00 | 8.999999999999998 |  |  |  | 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 | 10:30:00 | 19:30:00 | 9 |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
JESSICA | 13:00:00 | 20:30:00 | 7.5 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
SAM PAYET | 17:00:00 | 20:00:00 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
CON | 17:00:00 | 20:30:00 | 3.499999999999998 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
TOTAL HOURS |  |  | 83.5
 |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 7 | 7 | 8 | 8 | 8 | 7 | 6 | 7 | 8 | 8 | 7 | 7 | 6 | 7 | 7 | 7 | 7 | 6 | 5 | 5 | 4 | 2
FRIDAY | START TIME | FINISH TIME | 2008-10-31 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 | 12:30:00 | 5.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
STEPHANIE | 07:00:00 | 12:00:00 | 5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
DANIEL | 07:30:00 | 13:30:00 | 6 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
CON | 08:00:00 | 18:00:00 | 10 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
JESSICA | 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
MARK | 09:00:00 | 19:30:00 | 10.5 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
JODIE | 09:30:00 | 14:30:00 | 5 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 10:00:00 | 20:00:00 | 10 |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
MERYEM | 13:30:00 | 20:30:00 | 6.999999999999999 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
MELINDA | 14:00:00 | 20:00:00 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
ASHLEE | 16:30:00 | 20:30:00 | 3.999999999999999 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
TOTAL HOURS |  |  | 79
SATURDAY |  |  | 2008-11-01 00:00:00 |  |  | 2 | 2 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 3 | 2 | 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 | 19:00:00 | 19:30:00
ASHLEE | 08:00:00 | 13:00:00 | 5 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
RACHEL | 08:00:00 | 15:00:00 | 7 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
MARK | 09:00:00 | 16:30:00 | 7.5 |  | ` |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
JESSICA | 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
CASSANDRA | 12:00:00 | 19:00:00 | 6.999999999999999 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
TOTAL HOURS |  |  | 36
SUNDAY |  |  | 2008-11-02 00:00:00 |  |  | 2 | 2 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 2 | 2 | 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 | 19:00:00 | 19:30:00
ASHLEE | 08:00:00 | 13:00:00 | 5 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
CASSANDRA | 08:00:00 | 16:00:00 | 8 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
SAM PAYET | 09:00:00 | 16:00:00 | 6.999999999999999 |  | ` |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
MARK | 09:30:00 | 21:00:00 | 11.5 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
MERYEM | 13:00:00 | 19:30:00 | 6.500000000000001 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
TOTAL HOURS |  |  | 38
TOTAL HOURS
 |  |  | 488.5
ASHLEE |  |  | 34.5
CASSANDRA |  |  | 24.5
CON |  |  | 40
CATHY |  |  | 12
DANIEL |  |  | 39
JESSICA |  |  | 39.5
[NAME] |  |  | 36.5
JODIE |  |  | 5
MARK |  |  | 39.5
MELINDA |  |  | 33.5
MERYEM |  |  | 39.5
RACHEL |  |  | 36.5
SAMANTHA |  |  | 31.5
SAM P |  |  | 41
STEPHANIE |  |  | 36
TOTAL |  |  | 488.5