Spreadsheet: 118373d1313631065-excel-formula-help-for-timesheets-timesheet-final
Sheet: Sheet1

2011-08-01 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-08-01 00:00:00 | 04:30:00 |  | 13:00:00 |  | 8 | 240 | 7.549516567451064e-15 | 0 | 3.397282455352979e-13 | 0 | 0 | 240.0000000000003 | 30 |  |  |  |  | 04:30:00 | 30 |  | 04:30:00 | 00:30:00
2011-08-02 00:00:00 | 04:30:00 |  | 13:00:00 |  | 8 | 240 | 7.549516567451064e-15 | 0 | 3.61772833912255e-13 | 0 | 0 | 240.0000000000004 | 30 |  |  |  |  | 06:00:00 | 40 |  | 06:00:00 | 01:00:00
2011-08-03 00:00:00 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 12:30:00 | 50 |  | 07:00:00 | 01:30:00
2011-08-04 00:00:00 | 04:30:00 |  | 17:00:00 |  | 8 | 240 | 2 | 10 | 95.84 | 1.999999999999993 | 127.7599999999996 | 473.5999999999996 | 30 |  |  |  |  | 14:00:00 | 60 |  | 12:30:00 | 02:00:00
2011-08-05 00:00:00 | 03:30:00 |  | 14:00:00 |  | 8 | 160 | 1.999999999999992 | 10 | 95.83999999999965 | 4.440892098500626e-16 | 2.8368418725222e-14 | 265.8399999999996 | 20 |  |  |  |  | Tea | 10 |  | 14:00:00 | 02:30:00
2011-08-06 00:00:00 | 07:00:00 |  | 11:00:00 |  | 3.999999999999991 | 319.9999999999993 | 0 | 0 | 0 | 0 | 0 | 319.9999999999993 | 40 |  |  |  |  |  |  |  |  | 03:00:00
2011-08-07 00:00:00 | 12:30:00 |  | 1900-01-01 00:00:00 |  | -12.5 | -1250 | 0 | 0 | 0 | 0 | 0 | -1250 | 50 |  |  |  |  |  |  |  |  | 03:30:00
2011-08-08 00:00:00 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 04:00:00
2011-08-09 00:00:00 | 14:00:00 |  | 23:30:00 |  | 8 | 480 | 1.000000000000007 | 10 | 47.92000000000032 | 4.440892098500626e-16 | 2.8368418725222e-14 | 537.9200000000003 | 60 |  |  |  |  |  |  |  |  | 04:30:00
2011-08-10 00:00:00 | 12:30:00 |  | 23:30:00 |  | 8 | 400 | 2 | 10 | 95.84 | 0.5000000000000071 | 31.94000000000046 | 537.7800000000005 | 50 |  |  |  |  |  |  |  |  | 05:00:00
2011-08-11 00:00:00 | 14:00:00 |  | 03:00:00 |  | -11 | -660 | 0 | 0 | 0 | 0 | 0 | -660 | 60 |  |  |  |  |  |  |  |  | 05:30:00
2011-08-12 00:00:00 | 12:30:00 |  | 20:30:00 |  | 7.500000000000007 | 375.0000000000003 | 0 | 0 | 0 | 0 | 0 | 375.0000000000003 | 50 |  |  |  |  |  |  |  |  | 06:00:00
2011-08-13 00:00:00 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 06:30:00
2011-08-14 00:00:00 | 06:00:00 |  | 22:00:00 |  | 8 | 640 | 2 | 10 | 95.84 | 5.500000000000007 | 351.3400000000005 | 1097.180000000001 | 40 |  |  |  |  |  |  |  |  | 07:00:00
 |  |  |  |  |  |  |  |  |  |  | sub total | 2177.320000000001 |  |  |  |  |  |  |  |  |  | 07:30:00
 |  |  |  |  |  |  |  |  |  |  | total | 1589.443600000001 |  |  |  |  |  |  |  |  |  | 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