Spreadsheet: 118279d1313587525-excel-formula-help-for-timesheets-timesheet-final
Sheet: Sheet1

2011-06-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start Time | Rate
Date | Start |  | Finish |  | Hours | SINGLE | Hours | Tea money | O/T 1.5 | Hours | O/T 2.0 | TOTAL $ | [NAME] |  |  |  |  | 03:30:00 | 20 |  | 03:30:00 | 1900-01-01 00:00:00
2011-06-20 00:00:00 | 04:30:00 |  | 13:00:00 |  | 8 | 240 | 0.5000000000000075 | 0 | 22.50000000000034 | 0 | 0 | 262.5000000000003 | 30 |  |  |  |  | 04:30:00 | 30 |  | 04:30:00 | 00:30:00
2011-06-21 00:00:00 | 04:30:00 |  | 13:30:00 |  | 8 | 240 | 1 | 10 | 45.00000000000002 | 0 | 0 | 295 | 30 |  |  |  |  | 06:00:00 | 40 |  | 06:00:00 | 01:00:00
2011-06-22 00:00:00 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 12:30:00 | 50 |  | 12:30:00 | 01:30:00
2011-06-23 00:00:00 | 04:30:00 |  | 14:30:00 |  | 8 | 240 | 2 | 10 | 90 | 6.661338147750939e-15 | 3.996802888650564e-13 | 340.0000000000004 | 30 |  |  |  |  | 14:00:00 | 60 |  | 14:00:00 | 02:00:00
2011-06-24 00:00:00 | 04:30:00 |  | 15:00:00 |  | 8 | 240 | 2 | 10 | 90 | 0.4999999999999996 | 29.99999999999997 | 370 | 30 |  |  |  |  | Tea | 10 |  |  | 02:30:00
2011-06-25 00:00:00 | 06:00:00 |  | 10:00:00 |  | 4.000000000000009 | 320.0000000000007 | 0 | 0 | 0 | 0 | 0 | 320.0000000000007 | 40 |  |  |  |  |  |  |  |  | 03:00:00
2011-06-26 00:00:00 | 04:30:00 |  | 16:00:00 |  | 8 | 480 | 2 | 10 | 90 | 1.500000000000007 | 90.0000000000004 | 670.0000000000005 | 30 |  |  |  |  |  |  |  |  | 03:30:00
2011-06-27 00:00:00 | 04:30:00 |  | 16:30:00 |  | 8 | 240 | 2 | 10 | 90 | 2 | 120 | 460 | 30 |  |  |  |  |  |  |  |  | 04:00:00
2011-06-28 00:00:00 | 04:30:00 |  | 17:00:00 |  | 8 | 240 | 2 | 10 | 90 | 2.499999999999992 | 149.9999999999995 | 489.9999999999995 | 30 |  |  |  |  |  |  |  |  | 04:30:00
2011-06-29 00:00:00 | 04:30:00 |  | 17:30:00 |  | 8 | 240 | 2 | 10 | 90 | 3.000000000000007 | 180.0000000000004 | 520.0000000000005 | 30 |  |  |  |  |  |  |  |  | 05:00:00
2011-06-30 00:00:00 | 04:30:00 |  | 18:00:00 |  | 8 | 240 | 2 | 10 | 90 | 3.5 | 210 | 550 | 30 |  |  |  |  |  |  |  |  | 05:30:00
2011-07-01 00:00:00 | 04:30:00 |  | 18:30:00 |  | 8 | 240 | 2 | 10 | 90 | 3.999999999999992 | 239.9999999999995 | 579.9999999999995 | 30 |  |  |  |  |  |  |  |  | 06:00:00
2011-07-02 00:00:00 | 04:30:00 |  | 19:00:00 |  | 8 | 480 | 2 | 10 | 90 | 4.500000000000007 | 270.0000000000005 | 850.0000000000005 | 30 |  |  |  |  |  |  |  |  | 06:30:00
2011-07-03 00:00:00 | 04:30:00 |  | 17:30:00 |  | 8 | 480 | 2 | 10 | 90 | 3.000000000000007 | 180.0000000000004 | 760.0000000000005 | 30 |  |  |  |  |  |  |  |  | 07:00:00
 |  |  |  |  |  |  |  |  |  |  | sub total | 6467.500000000002 |  |  |  |  |  |  |  |  |  | 07:30:00
 |  |  |  |  |  |  |  |  |  |  | total | 4721.275000000001 |  |  |  |  |  |  |  |  |  | 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