Spreadsheet: 148554d1333465437-possible-to-not-display-a-formula-result-if-less-than-say-0-new-new-new-rota-version2
Sheet: ROTA

 | RATE £7 / HOUR
W/C: | PRODUCE ROTA | 16.04.12 |  |  |  |  |  | L = LUNCH
DEPT/ | NAME |  | MON |  | L | M | M |  | TUE |  | L | T | T |  | WED |  | L | W | W |  | THUR |  | L | T | T |  | FRI |  | L | F | F |  | SAT |  | L | S | S |  | SUN |  | L | S | S | Hrs | Hrs | +/-
JOB TITLE |  | 08:00:00 | TRADE | 22:00:00 |  |  | H | 08:00:00 | TRADE | 22:00:00 |  |  | H | 08:00:00 | TRADE | 22:00:00 |  |  | H | 08:00:00 | TRADE | 22:00:00 |  |  | H | 08:00:00 | TRADE | 22:00:00 |  |  | H | 08:00:00 | TRADE | 22:00:00 |  |  | H | 10:00:00 | TRADE | 16:00:00 | 1 |  | H | TOTAL | Con | hours
MANAGER | [NAME] | 05:00:00 |  | 04:30:00 |  |  |  |  | DO |  |  |  |  |  | DO |  |  |  |  | 06:00:00 |  | 16:00:00 | 1 |  |  | 12:00:00 |  | 21:00:00 | 1 |  |  | 06:00:00 |  | 17:00:00 |  |  |  | 08:00:00 |  | 17:00:00 | 1 |  |  |  | 43
AST MANAGER | JON BURNS |  | DO |  |  |  |  |  |  |  |  |  |  | 07:00:00 |  | 17:00:00 | 1 |  |  | 12:00:00 |  | 21:00:00 | 1 |  |  | 07:00:00 |  | 16:00:00 | 1 |  |  | 12:00:00 |  | 18:00:00 | 1 |  |  |  | DO |  |  |  |  |  | 39
FULL TIME | STE BROOKSBANK | 12:00:00 |  | 21:00:00 | 1 |  |  |  | DO |  |  |  |  |  | DO |  |  |  |  | 07:00:00 |  | 16:00:00 | 1 |  |  | 10:00:00 |  | 19:00:00 | 1 |  |  | 12:30:00 |  | 21:30:00 | 1 |  |  | 09:00:00 |  | 18:00:00 | 1 |  |  |  | 39
FULL TIME | [NAME] DODD |  | DO |  |  |  |  |  |  |  |  |  |  | 10:00:00 |  | 19:00:00 | 1 |  |  | 10:00:00 |  | 18:00:00 | 1 |  |  | 08:00:00 |  | 17:00:00 | 1 |  |  | 07:00:00 |  | 16:00:00 | 1 |  |  |  | DO |  |  |  |  |  | 39
FULL TIME | [NAME] |  | DO |  |  |  |  |  |  |  |  |  |  | 08:00:00 |  | 17:00:00 | 1 |  |  |  | DO |  |  |  |  | 07:00:00 |  | 15:00:00 | 1 |  |  | 12:00:00 |  | 21:00:00 | 1 |  |  | 10:00:00 |  | 19:00:00 | 1 |  |  |  | 39
FULL TIME | [NAME] |  | H |  |  |  |  |  | O |  |  |  |  |  | L |  |  |  |  |  | I |  |  |  |  |  | D |  |  |  |  |  | A |  |  |  |  |  | Y |  |  |  |  |  | 39
FULL TIME | R WINSPERE | 08:00:00 |  | 17:00:00 | 1 |  |  |  |  |  |  |  |  |  | DO |  |  |  |  | 14:00:00 |  | 22:00:00 |  |  |  | 14:00:00 |  | 22:00:00 |  |  |  |  | DO |  |  |  |  | 12:00:00 |  | 19:00:00 |  |  |  |  | 39
PART  TIME | L OGDEN | 15:00:00 |  | 22:00:00 |  |  |  |  |  |  |  |  |  | 15:00:00 |  | 22:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 |  | 17:30:00 | 1 |  |  |  |  |  |  |  |  |  | 20.5
[NAME] | [NAME] | 07:00:00 |  | 16:00:00 | 1 |  |  |  |  |  |  |  |  | 07:00:00 |  | 11:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00 |  | 16:30:00 | 1 |  |  |  | 20
GARDEN C
GARDEN C
GARDEN C | PAUL WOODALL | 09:30:00 |  | 19:30:00 | 1 |  |  |  |  |  |  |  |  |  | DO |  |  |  |  | 09:30:00 |  | 16:30:00 | 1 |  |  | 09:30:00 |  | 18:00:00 | 1 |  |  | 09:30:00 |  | 19:00:00 | 1 |  |  |  | DO |  |  |  |  |  | 39
GARDEN C | CHRIS LAYCOCK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:30:00 |  | 18:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:30:00 |  | 17:00:00 |  |  |  |  | 14
NIGHTS FT | [NAME] DAYMAN | 1900-01-01 00:00:00 |  | 08:00:00 |  |  |  |  | DO |  |  |  |  |  | DO |  |  |  |  | 1900-01-01 00:30:00 |  | 08:00:00 |  |  |  | 1900-01-01 00:00:00 |  | 08:00:00 |  |  |  | 1900-01-01 00:30:00 |  | 08:00:00 |  |  |  | 01:00:00 |  | 09:00:00 |  |  |  |  | 39
NIGHTS FT | RICKI LEDGER |  | DO |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 |  | 08:00:00 |  |  |  | 1900-01-01 00:30:00 |  | 08:00:00 |  |  |  | 1900-01-01 00:00:00 |  | 08:00:00 |  |  |  | 1900-01-01 00:30:00 |  | 08:00:00 |  |  |  |  | DO |  |  |  |  |  | 39
DAILY | TOTAL HOURS
 | COST / DAY
DAILY % OF | WEEKLY HOURS
 | RED = FLOWER SETUP
 |  | Time | Staff
 |  | 00:00:00
 |  | 00:30:00
 |  | 01:00:00
 |  | 01:30:00
 |  | 02:00:00
 |  | 02:30:00
 |  | 03:00:00
 |  | 03:30:00
 |  | 04:00:00
 |  | 04:30:00
 |  | 05:00:00
 |  | 05:30:00
 |  | 06:00:00
 |  | 06:30: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
 |  | 21:00:00
 |  | 21:30:00
 |  | 22:00:00
 |  | 22:30:00
 |  | 23:00:00
 |  | 23:30:00