Spreadsheet: 83414d1283403482-problem-w-formula-and-empty-cells-staff-schedule-0830-0905
Sheet: Layout1

 | August |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Total | Payroll
 |  |  | 2010-08-30 00:00:00 | 2010-08-31 00:00:00 | 2010-09-01 00:00:00 | 2010-09-02 00:00:00 | 2010-09-03 00:00:00 | 2010-09-04 00:00:00 | 2010-09-05 00:00:00 |  | $$
15.5 | Gustavo | In |  | 11:00:00 |  | 11:00:00 | 11:00:00 | 11:00:00 | 11:00:00 | 20 | 542.5
 |  | Out |  | 15:00:00 |  | 15:00:00 | 15:00:00 | 15:00:00 | 15:00:00
 |  | In |  | 17:00:00 |  | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00 | 15
 |  | Out |  | 20:00:00 |  | 20:00:00 | 20:00:00 | 20:00:00 | 20:00:00
12 | [NAME] | In |  |  |  |  |  |  |  |  | 342
 |  | Out
 |  | In | 16:30:00 |  |  | 16:30:00 | 16:30:00 | 16:30:00 | 16:30:00 | 28.5
 |  | Out | 22:00:00 |  |  | 22:00:00 | 22:30:00 | 22:30:00 | 22:00:00
12 | [NAME] | In | 11:00:00 |  | 11:00:00 |  |  | 11:00:00 |  | #N/A | #N/A
 |  | Out | 15:00:00 |  | 15:00:00 |  |  | 15:00:00
 |  | In | 17:30:00 |  | 17:30:00 |  |  | 18:00:00 |  | #N/A
 |  | Out | 22:00:00 |  | 22:00:00 |  |  | 22:30:00
13 | [NAME] | In |  |  | 11:00:00 |  |  |  |  | 4 | 250.25
 |  | Out |  |  | 15:00:00
 |  | In |  | 17:00:00 | 16:45:00 |  | 17:00:00 |  |  | 15.25
 |  | Out |  | 22:00:00 | 21:30:00 |  | 22:30:00
9.5 | [NAME] | In |  |  |  |  |  |  |  | 0 | 247
 |  | Out
 |  | In | 17:30:00 | 17:30:00 | 17:00:00 |  | 17:00:00 | 17:00:00 |  | 26
 |  | Out | 22:00:00 | 22:00:00 | 22:00:00 |  | 23:00:00 | 23:00:00
9 | Yoshi | In |  |  |  |  |  |  |  | 0 | 85.49999999999999
 |  | Out
 |  | In |  |  |  | 17:30:00 |  |  | 17:00:00 | 9.499999999999998
 |  | Out |  |  |  | 22:00:00 |  |  | 22:00:00
10 | Anna | In | 11:00:00 | 11:00:00 |  | 11:00:00 | 11:00:00 |  |  | #N/A | #N/A
 |  | Out | 14:30:00 | 14:30:00 |  | 14:30:00 | 14:30:00
 |  | In |  |  |  |  |  |  |  | 0
 |  | Out |  |  |  |  |  |  |  |  |  | #N/A
8 | [NAME] | In |  |  |  |  |  |  |  | 0 | 87.99999999999999
 |  | Out
 |  | In |  |  |  | 17:00:00 |  | 17:00:00 |  | 11
 |  | Out |  |  |  | 22:00:00 |  | 23:00:00
8 | [NAME] | In |  |  | 11:00:00 |  |  |  | 11:00:00 | 8 | 110
 |  | Out |  |  | 15:00:00 |  |  |  | 15:00:00
 |  | In |  |  |  |  | 16:45:00 |  |  | 5.750000000000001
 |  | Out |  |  |  |  | 22:30:00
8 | Sonja | In |  |  |  |  |  |  |  | 0 | #N/A
 |  | Out
 |  | In |  |  |  | 16:45:00 | 17:00:00 | 16:45:00 |  | #N/A
 |  | Out |  |  |  | 21:00:00 | 21:30:00 | 21:30:00
8 | Juan | In |  |  |  |  |  |  |  | 0 | 126
 |  | Out
 |  | In | 16:45:00 | 16:45:00 | 16:45:00 |  |  |  |  | 15.75
 |  | Out | 22:00:00 | 22:00:00 | 22:00:00
8 | Leah | In | 11:00:00 | 11:00:00 |  | 11:00:00 |  |  |  | 12 | 96
 |  | Out | 15:00:00 | 15:00:00 |  | 15:00:00
 |  | In |  |  |  |  |  |  |  | 0
 |  | Out
8 | [NAME] | In |  |  |  |  | 11:00:00 | 11:00:00 |  | 8 | 106
 |  | Out |  |  |  |  | 15:00:00 | 15:00:00
 |  | In |  |  |  |  |  |  | 16:45:00 | 5.25
 |  | Out |  |  |  |  |  |  | 22:00:00
8 | Dawn | In |  |  |  |  |  |  |  | 0 | 0
 |  | Out
 |  | In |  |  |  |  |  |  |  | 0
 |  | Out
8 | Tiffany | In |  |  |  |  |  |  |  | 0 | 63.99999999999996
 |  | Out
 |  | In |  |  | 18:30:00 |  | 18:30:00 | 18:30:00 | 18:00:00 | 7.999999999999996
 |  | Out |  |  | 20:30:00 |  | 20:30:00 | 20:30:00 | 20:00:00
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | Projected Sales
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  | In |  |  |  |  |  |  |  | 0 | 0
 |  | Out
 |  | In |  |  |  |  |  |  |  | 0
 |  | Out
 |  | In |  |  |  |  |  |  |  | 0 | 0
 |  | Out
 |  | In |  |  |  |  |  |  |  | 0
 |  | Out
 |  | In |  |  |  |  |  |  |  | 0 | 0
 |  | Out
 |  | In |  |  |  |  |  |  |  | 0
 |  | Out
 |  | In |  |  |  |  |  |  |  | 0 | 0
 |  | Out
 |  | In |  |  |  |  |  |  |  | 0
 |  | Out