Spreadsheet: 186370d1350009309-urgent-help-required-a-few-questions-regarding-a-staff-sheet-i-am-doing-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-01 12:00:00 | 2012-10-01 16:45:00 | 4.749999999941792 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 2012-10-01 08:00:00 | 2012-10-01 14:00:00 | 6 | 15 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 2012-10-01 12:00:00 | 2012-10-01 22:45:00 | 10.74999999994179 | 75 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0
[NAME] | 0 | 2012-10-01 13:00:00 | 2012-10-01 17:00:00 | 4.000000000116415 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0
RICHARD RUST | 0 | 2012-10-01 18:00:00 | 2012-10-01 22:00:00 | 3.999999999941792 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0
PATRICIA PUMA | 0 | 2012-10-01 12:00:00 | 2012-10-01 23:30:00 | 11.49999999994179 | 75 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
BRANDON BON | 0 | 2012-10-01 13:00:00 | 2012-10-02 00:00:00 | 11.00000000005821 | 75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 0 | 2012-10-01 14:00:00 | 2012-10-02 01:00:00 | 10.99999999988358 | 75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 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.000000000058208 | 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.000000000116415 | 15
 | 0 | 2012-10-01 18:00:00 | 2012-10-01 22:00:00 | 3.999999999941792 | 0
 | 0 | 2012-10-01 12:00:00 | 2012-10-01 23:30:00 | 11.49999999994179 | 75
 | 0 | 2012-10-01 13:00:00 | 2012-10-02 00:00:00 | 11.00000000005821 | 75
 | 0 | 2012-10-01 14:00:00 | 2012-10-02 01:00:00 | 10.99999999988358 | 75
 | 0 | 2012-10-01 15:00:00 | 2012-10-02 02:00:00 | 11.00000000005821 | 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.000000000116415 | 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.000000000116415 | 15
 | 0 | 2012-10-01 18:00:00 | 2012-10-01 22:00:00 | 3.999999999941792 | 0
 | 0 | 2012-10-01 12:00:00 | 2012-10-01 23:30:00 | 11.49999999994179 | 75
 | 0 | 2012-10-01 13:00:00 | 2012-10-02 00:00:00 | 11.00000000005821 | 75
 | 0 | 2012-10-01 14:00:00 | 2012-10-02 01:00:00 | 10.99999999988358 | 75
 | 0 | 2012-10-01 15:00:00 | 2012-10-02 02:00:00 | 11.00000000005821 | 75