Spreadsheet: 27701d1221152456-how-to-get-rid-of-value-in-a-cell-time-sheetforum
Sheet: SEPT

 |  | SEPTEMBER 2008 TIMESHEET
DATE |  | START | FINISH | HOURS | BREAK |  | DAILY CONTRACTED HOURS |  |  |  | O/TIME | TOTAL |  | HOURS @ £7 PRE 2000HRS | HOURS @ £8.75 POST 20:00HRS | DAILY PAY
 |  | TIME | TIME | WORKED | DURATION |  | Start | Finish | Hours |  | HOURS | HOURS
Sun
Mon | 2008-09-01 00:00:00 | 18:00:00 | 22:00:00 | 04:00:00 |  |  | 17:30:00 | 20:45:00 | 03:15:00 |  | 01:15:00 | 04:30:00 |  | 2.500000000000002 | 1.999999999999998 | 35
Tue | 2008-09-02 00:00:00 | 18:00:00 | 21:30:00 | 03:30:00 |  |  | 17:30:00 | 20:45:00 | 03:15:00 |  | 00:45:00 | 04:00:00 |  | 2.500000000000002 | 1.5 | 30.62500000000001
Wed | 2008-09-03 00:00:00 | 17:00:00 | 21:30:00 | 04:30:00 |  |  | 17:30:00 | 20:45:00 | 03:15:00 |  | 01:15:00 | 04:30:00 |  | 3 | 1.5 | 34.125
Thu | 2008-09-04 00:00:00 | 18:00:00 | 22:00:00 | 04:00:00 |  |  | 17:30:00 | 20:45:00 | 03:15:00 |  | 01:15:00 | 04:30:00 |  | 2.500000000000002 | 1.999999999999998 | 35
Fri | 2008-09-05 00:00:00 | 18:00:00 | 22:00:00 | 04:00:00 |  |  | 17:30:00 | 20:45:00 | 03:15:00 |  | 01:15:00 | 04:30:00 |  | 2.500000000000002 | 1.999999999999998 | 35
Sat | 2008-09-06 00:00:00
Sun | 2008-09-07 00:00:00
 |  |  |  | 20:00:00 |  |  |  |  | 16:15:00 |  | 05:45:00 | 22:00:00 |  | 91.00000000000006 | 78.74999999999996 | 169.75
Mon | 2008-09-08 00:00:00 | 18:00:00 | 21:45:00 | 03:45:00 |  |  | 17:30:00 | 20:45:00 | 03:15:00 |  | 01:00:00 | 04:15:00 |  | 2.500000000000002 | 1.749999999999999 | 32.81250000000001
Tue | 2008-09-09 00:00:00 | 17:30:00 | 20:45:00 | 03:15:00 |  |  | 17:30:00 | 20:45:00 | 03:15:00 |  | 1900-01-01 00:00:00 | 03:15:00 |  | 2.500000000000002 | 0.75 | 24.06250000000001
Wed | 2008-09-10 00:00:00 | 18:00:00 | 21:45:00 | 03:45:00 |  |  | 17:30:00 | 20:45:00 | 03:15:00 |  | 01:00:00 | 04:15:00 |  | 2.500000000000002 | 1.749999999999999 | 32.81250000000001
Thu | 2008-09-11 00:00:00 |  |  |  |  |  | 17:30:00 | 20:45:00 | 03:15:00 |  |  |  |  |  | #N/A | #N/A
Fri | 2008-09-12 00:00:00 |  |  |  |  |  | 17:30:00 | 20:45:00 | 03:15:00 |  |  |  |  |  | #N/A | #N/A
Sat | 2008-09-13 00:00:00
Sun | 2008-09-14 00:00:00
 |  |  |  | 10:45:00 |  |  |  |  | 16:15:00 |  | 02:00:00 | 11:45:00 |  | 52.50000000000004 | #N/A | #N/A
Mon | 2008-09-15 00:00:00 |  |  |  |  |  | 17:30:00 | 20:45:00 | 03:15:00 |  |  |  |  |  | #N/A | #N/A
Tue | 2008-09-16 00:00:00 |  |  |  |  |  | 17:30:00 | 20:45:00 | 03:15:00 |  |  |  |  |  | #N/A | #N/A
Wed | 2008-09-17 00:00:00 |  |  |  |  |  | 17:30:00 | 20:45:00 | 03:15:00 |  |  |  |  |  | #N/A | #N/A
Thu | 2008-09-18 00:00:00 |  |  |  |  |  | 17:30:00 | 20:45:00 | 03:15:00 |  |  |  |  |  | #N/A | #N/A
Fri | 2008-09-19 00:00:00 |  |  |  |  |  | 17:30:00 | 20:45:00 | 03:15:00 |  |  |  |  |  | #N/A | #N/A
Sat | 2008-09-20 00:00:00
Sun | 2008-09-21 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  | 16:15:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 0 | #N/A | #N/A
Mon | 2008-09-22 00:00:00 |  |  |  |  |  | 17:30:00 | 20:45:00 | 03:15:00 |  |  |  |  |  | #N/A | #N/A
Tue | 2008-09-23 00:00:00 |  |  |  |  |  | 17:30:00 | 20:45:00 | 03:15:00 |  |  |  |  |  | #N/A | #N/A
Wed | 2008-09-24 00:00:00 |  |  |  |  |  | 17:30:00 | 20:45:00 | 03:15:00 |  |  |  |  |  | #N/A | #N/A
Thu | 2008-09-25 00:00:00 |  |  |  |  |  | 17:30:00 | 20:45:00 | 03:15:00 |  |  |  |  |  | #N/A | #N/A
Fri | 2008-09-26 00:00:00 |  |  |  |  |  | 17:30:00 | 20:45:00 | 03:15:00 |  |  |  |  |  | #N/A | #N/A
Sat | 2008-09-27 00:00:00
Sun | 2008-09-28 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  | 16:15:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 0 | #N/A | #N/A
Mon | 2008-09-29 00:00:00 |  |  |  |  |  | 17:30:00 | 20:45:00 | 03:15:00 |  |  |  |  |  | #N/A | #N/A
Tue | 2008-09-30 00:00:00 |  |  |  |  |  | 17:30:00 | 20:45:00 | 03:15:00 |  |  |  |  |  | #N/A | #N/A
Wed
Thu
Fri
Sat
Sun
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  | 06:30:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 0 | #N/A | #N/A