Spreadsheet: 69748d1270374225-nested-if-and-formula-sample1
Sheet: Schedule 1

 | Weekly Schedule
 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
 | 2010-03-29 00:00:00 |  | 2010-03-30 00:00:00 |  | 2010-03-31 00:00:00 |  | 2010-04-01 00:00:00 |  | 2010-04-02 00:00:00 |  | 2010-04-03 00:00:00 |  | 2010-04-04 00:00:00 |  | TOTAL
 | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out
Debbie |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
Gina | 06:00:00 | 14:00:00 |  |  | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 |  |  | 06:00:00 | 14:00:00 | 40 |  | 8 |  | 8 | 0 |  | 0 | 8 |  | 8 | 8 |  | 8 | 8 |  | 8 | 0 |  | 0 | 8 |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
Samantha |  |  | 06:00:00 | 14:00:00 | 07:00:00 | 14:00:00 | 07:30:00 | 15:30:00 | 07:00:00 | 14:00:00 | 07:00:00 | 15:00:00 |  |  | 38 |  | 0 |  | 0 | 8 |  | 8 | 7 |  | 7 | 8 |  | 8 | 7 |  | 7 | 8 |  | 8 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
[NAME] | 07:00:00 | 10:00:00 | 07:00:00 | 15:00:00 | 14:00:00 | 19:00:00 | 07:00:00 | 10:00:00 | 07:30:00 | 15:00:00 |  |  |  |  | 39.5 |  | 3 |  | 3 | 8 |  | 8 | 5 |  | 5 | 3 |  | 3 | 7.5 |  | 7.5 | 0 |  | 0 | 0 |  | 0
 | 12:00:00 | 19:00:00 |  |  |  |  | 16:00:00 | 19:00:00 | 16:00:00 | 19:00:00 |  |  |  |  |  |  | 7 |  | 7 | 0 |  | 0 | 0 |  | 0 | 3 |  | 3 | 3 |  | 3 | 0 |  | 0 | 0 |  | 0
Beverly | 07:30:00 | 14:30:00 |  |  | 14:00:00 | 22:00:00 |  |  |  |  |  |  |  |  | 15 |  | 7 |  | 7 | 0 |  | 0 | 8 |  | 8 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
Rachel | 14:30:00 | 21:00:00 | 15:00:00 | 21:00:00 | 15:00:00 | 21:00:00 |  |  | 14:00:00 | 21:00:00 |  |  | 14:00:00 | 20:00:00 | 31.5 |  | 6.5 |  | 6.5 | 6 |  | 6 | 6 |  | 6 | 0 |  | 0 | 7 |  | 7 | 0 |  | 0 | 6 |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
[NAME] | 16:00:00 | 22:00:00 | 16:00:00 | 22:00:00 |  |  | 15:30:00 | 22:00:00 | 15:00:00 | 1900-01-01 00:00:00 |  |  | 16:00:00 | 1900-01-01 00:00:00 | 35.5 |  | 6 |  | 6 | 6 |  | 6 | 0 |  | 0 | 6.5 |  | 6.5 | -15 |  | 9 | 0 |  | 0 | -16 |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
Cait |  |  | 07:30:00 | 10:00:00 |  |  | 12:00:00 | 21:00:00 | 08:00:00 | 16:00:00 | 16:00:00 | 21:00:00 |  |  | 31.5 |  | 0 |  | 0 | 2.5 |  | 2.5 | 0 |  | 0 | 9 |  | 9 | 8 |  | 8 | 5 |  | 5 | 0 |  | 0
 |  |  | 12:00:00 | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 7 |  | 7 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
Kathy | 22:00:00 | 06:00:00 | 22:00:00 | 06:00:00 | 22:00:00 | 06:00:00 | 22:00:00 | 06:00:00 |  |  |  |  |  |  | 32 |  | -16 |  | 8 | -16 |  | 8 | -16 |  | 8 | -16 |  | 8 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
Gloria |  |  |  |  |  |  |  |  |  |  | 08:00:00 | 16:00:00 | 08:00:00 | 16:00:00 | 16 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 8 |  | 8 | 8 |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  | 09:00:00 | 21:00:00 |  |  | 12 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 12 |  | 12 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
Up For Grabs |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 08:00:00 | 21:00:00 | 06:00:00 | 1900-01-01 00:00:00 | 06:00:00 | 23 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 8 |  | 8 | -15 |  | 9 | 6 |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0