Spreadsheet: 69474d1270018020-time-formula-going-back-to-zero-payrollcalc
Sheet: Sheet3

 | Regular | Split | Up For Grabs | Holiday | Total Hours | Overtime | Vaction | Sick | Incentive
Week 1
Week 2
Total Hours Week 2 |  |  |  |  |  | Total Hours Week 2
Day | Date | In | Out | Total |  | Day | Date | In | Out | Total
Monday | 2010-03-22 00:00:00 | 06:00:00 | 14:00:00 | 08:00:00 |  | Monday | 2010-03-29 00:00:00 | 06:00:00 | 14:00:00 | 08:00:00
 |  | 06:00:00 | 14:00:00 | 08:00:00 |  |  |  | 06:00:00 | 14:00:00 | 08:00:00
Tuesday | 2010-03-23 00:00:00 | 14:00:00 | 17:00:00 | 03:00:00 |  | Tuesday | 2010-03-30 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Wednesday | 2010-03-24 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Wednesday | 2010-03-31 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Thursday | 2010-03-25 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Thursday | 2010-04-01 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Friday | 2010-03-26 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Friday | 2010-04-02 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Satruday | 2010-03-27 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Satruday | 2010-04-03 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Sunday | 2010-03-28 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Sunday | 2010-04-04 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  | 19:00:00 |  |  |  |  |  | 16:00:00
[NAME] |  |  |  |  |  | [NAME]
Day | Date | In | Out | Total |  | Day | Date | In | Out | Total
Monday | 2010-03-22 00:00:00 | 01:00:00 | 02:00:00 | 01:00:00 |  | Monday | 2010-03-22 00:00:00 |  |  | 1900-01-01 00:00:00
 |  | 06:21:00 | 14:00:00 | 07:39:00 |  |  |  |  |  | 1900-01-01 00:00:00
Tuesday | 2010-03-23 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Tuesday | 2010-03-23 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Wednesday | 2010-03-24 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Wednesday | 2010-03-24 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Thursday | 2010-03-25 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Thursday | 2010-03-25 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Friday | 2010-03-26 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Friday | 2010-03-26 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Satruday | 2010-03-27 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Satruday | 2010-03-27 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Sunday | 2010-03-28 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Sunday | 2010-03-28 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  | 08:39:00 |  |  |  |  |  | 1900-01-01 00:00:00
Up For Grabs Hours Week 1 |  |  |  |  |  | Up For Grabs Hours Week 1
Day | Date | In | Out | Total |  | Day | Date | In | Out | Total
Monday | 2010-03-22 00:00:00 | 01:00:00 | 02:00:00 | 01:00:00 |  | Monday | 2010-03-22 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Tuesday | 2010-03-23 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Tuesday | 2010-03-23 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Wednesday | 2010-03-24 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Wednesday | 2010-03-24 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Thursday | 2010-03-25 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Thursday | 2010-03-25 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Friday | 2010-03-26 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Friday | 2010-03-26 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Satruday | 2010-03-27 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Satruday | 2010-03-27 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Sunday | 2010-03-28 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Sunday | 2010-03-28 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  | 01:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Holiday Hours Week 1 |  |  |  |  |  | Holiday Hours Week 1
Day | Date | In | Out | Total |  | Day | Date | In | Out | Total
Monday | 2010-03-22 00:00:00 | 01:00:00 | 02:00:00 | 01:00:00 |  | Monday | 2010-03-22 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Tuesday | 2010-03-23 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Tuesday | 2010-03-23 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Wednesday | 2010-03-24 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Wednesday | 2010-03-24 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Thursday | 2010-03-25 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Thursday | 2010-03-25 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Friday | 2010-03-26 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Friday | 2010-03-26 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Satruday | 2010-03-27 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Satruday | 2010-03-27 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Sunday | 2010-03-28 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Sunday | 2010-03-28 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  | 01:00:00 |  |  |  |  |  | 1900-01-01 00:00:00