Spreadsheet: 184532d1349287643-is-it-possible-to-change-the-colour-of-cells-based-on-hours-inputted-on-a-staffing-rota-foodsstaffing-copy
Sheet: Sheet 1 - Table 1

 | S T A F F I N G  S H E E T
 | AREA A
 | Shift Details |  |  |  |  | 2012-10-01 06:00:00 | 2012-10-01 07:00:00 | 2012-10-01 08:00:00 | 2012-10-01 09:00:00 | 2012-10-01 10:00:00 | 2012-10-01 11:00:00 | 2012-10-01 12:00:00 | 2012-10-01 13:00:00 | 2012-10-01 14:00:00 | 2012-10-01 15:00:00 | 2012-10-01 16:00:00 | 2012-10-01 17:00:00 | 2012-10-01 18:00:00 | 2012-10-01 19:00:00 | 2012-10-01 20:00:00 | 2012-10-01 21:00:00 | 2012-10-01 22:00:00 | 2012-10-01 23:00:00
 | 1 | Start | Finish | Duration | Break | 2012-10-01 07:00:00 | 2012-10-01 08:00:00 | 2012-10-01 09:00:00 | 2012-10-01 10:00:00 | 2012-10-01 11:00:00 | 2012-10-01 12:00:00 | 2012-10-01 13:00:00 | 2012-10-01 14:00:00 | 2012-10-01 15:00:00 | 2012-10-01 16:00:00 | 2012-10-01 17:00:00 | 2012-10-01 18:00:00 | 2012-10-01 19:00:00 | 2012-10-01 20:00:00 | 2012-10-01 21:00:00 | 2012-10-01 22:00:00 | 2012-10-01 23:00:00 | 2012-10-01 00:00:00
ZOE BALL | 0 | 2012-10-02 12:00:00 | 2012-10-02 16:45:00 | 4.75 | 15
[NAME] | 0 | 2012-10-01 08:00:00 | 2012-10-01 14:00:00 | 6 | 15
[NAME] | 0 | 2012-10-01 12:00:00 | 2012-10-01 22:45:00 | 10.75 | 75
[NAME] | 0 | 2012-10-01 13:00:00 | 2012-10-01 17:00:00 | 4 | 15
RICHARD RUST | 0 | 2012-10-01 18:00:00 | 2012-10-01 22:00:00 | 4 | 15
PATRICIA PUMA | 0 | 2012-10-01 12:00:00 | 2012-10-01 23:30:00 | 11.5 | 75
BRANDON BON | 0 | 2012-10-01 13:00:00 | 2012-10-02 00:00:00 | 11 | 75
[NAME] | 0 | 2012-10-01 14:00:00 | 2012-10-02 01:00:00 | 11 | 75
 | AREA B
 | Shift Details |  |  |  |  | 2012-10-01 06:00:00 | 2012-10-01 07:00:00 | 2012-10-01 08:00:00 | 2012-10-01 09:00:00 | 2012-10-01 10:00:00 | 2012-10-01 11:00:00 | 2012-10-01 12:00:00 | 2012-10-01 13:00:00 | 2012-10-01 14:00:00 | 2012-10-01 15:00:00 | 2012-10-01 16:00:00 | 2012-10-01 17:00:00 | 2012-10-01 18:00:00 | 2012-10-01 19:00:00 | 2012-10-01 20:00:00 | 2012-10-01 21:00:00 | 2012-10-01 22:00:00 | 2012-10-01 23:00:00
 | 1 | Start | Finish | Duration | Break | 2012-10-01 07:00:00 | 2012-10-01 08:00:00 | 2012-10-01 09:00:00 | 2012-10-01 10:00:00 | 2012-10-01 11:00:00 | 2012-10-01 12:00:00 | 2012-10-01 13:00:00 | 2012-10-01 14:00:00 | 2012-10-01 15:00:00 | 2012-10-01 16:00:00 | 2012-10-01 17:00:00 | 2012-10-01 18:00:00 | 2012-10-01 19:00:00 | 2012-10-01 20:00:00 | 2012-10-01 21:00:00 | 2012-10-01 22:00:00 | 2012-10-01 23:00:00 | 2012-10-01 00:00:00
 | 0 | 2012-10-01 12:00:00 | 2012-10-01 14:00:00 | 2 | 0
 | 0 | 2012-10-01 08:00:00 | 2012-10-01 14:00:00 | 6 | 15
 | 0 | 2012-10-01 12:00:00 | 2012-10-01 22:30:00 | 10.5 | 75
 | 0 | 2012-10-01 13:00:00 | 2012-10-01 17:00:00 | 4 | 15
 | 0 | 2012-10-01 18:00:00 | 2012-10-01 22:00:00 | 4 | 15
 | 0 | 2012-10-01 12:00:00 | 2012-10-01 23:30:00 | 11.5 | 75
 | 0 | 2012-10-01 13:00:00 | 2012-10-02 00:00:00 | 11 | 75
 | 0 | 2012-10-01 14:00:00 | 2012-10-02 01:00:00 | 11 | 75
 | 0 | 2012-10-01 15:00:00 | 2012-10-02 02:00:00 | 11 | 75
 | AREA C
 | Shift Details |  |  |  |  | 2012-10-01 06:00:00 | 2012-10-01 07:00:00 | 2012-10-01 08:00:00 | 2012-10-01 09:00:00 | 2012-10-01 10:00:00 | 2012-10-01 11:00:00 | 2012-10-01 12:00:00 | 2012-10-01 13:00:00 | 2012-10-01 14:00:00 | 2012-10-01 15:00:00 | 2012-10-01 16:00:00 | 2012-10-01 17:00:00 | 2012-10-01 18:00:00 | 2012-10-01 19:00:00 | 2012-10-01 20:00:00 | 2012-10-01 21:00:00 | 2012-10-01 22:00:00 | 2012-10-01 23:00:00
 | 1 | Start | Finish | Duration | Break | 2012-10-01 07:00:00 | 2012-10-01 08:00:00 | 2012-10-01 09:00:00 | 2012-10-01 10:00:00 | 2012-10-01 11:00:00 | 2012-10-01 12:00:00 | 2012-10-01 13:00:00 | 2012-10-01 14:00:00 | 2012-10-01 15:00:00 | 2012-10-01 16:00:00 | 2012-10-01 17:00:00 | 2012-10-01 18:00:00 | 2012-10-01 19:00:00 | 2012-10-01 20:00:00 | 2012-10-01 21:00:00 | 2012-10-01 22:00:00 | 2012-10-01 23:00:00 | 2012-10-01 00:00:00
 | 0 | 2012-10-01 07:00:00 | 2012-10-01 14:00:00 | 7 | 60
 | 0 | 2012-10-01 08:00:00 | 2012-10-01 14:00:00 | 6 | 15
 | 0 | 2012-10-01 12:00:00 | 2012-10-01 22:30:00 | 10.5 | 75
 | 0 | 2012-10-01 13:00:00 | 2012-10-01 17:00:00 | 4 | 15
 | 0 | 2012-10-01 18:00:00 | 2012-10-01 22:00:00 | 4 | 15
 | 0 | 2012-10-01 12:00:00 | 2012-10-01 23:30:00 | 11.5 | 75
 | 0 | 2012-10-01 13:00:00 | 2012-10-02 00:00:00 | 11 | 75
 | 0 | 2012-10-01 14:00:00 | 2012-10-02 01:00:00 | 11 | 75
 | 0 | 2012-10-01 15:00:00 | 2012-10-02 02:00:00 | 11 | 75