Spreadsheet: 27703d1221153818-how-to-get-rid-of-value-in-a-cell-time-sheetforum-1
Sheet: AUG

 |  | AUGUST 2008 TIMESHEET
DATE |  | START | FINISH | HOURS |  | DAILY CONTRACTED HOURS |  |  |  | O/TIME | TOTAL | HOURS @ £7 BASIC RATE | HOURS @ £8.75 EVENING RATE | DAILY PAY
 |  | TIME | TIME | WORKED |  | Start | Finish | Hours |  | HOURS | HOURS
Sun | 2008-08-03 00:00:00
Mon | 2008-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Tue | 2008-08-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Wed | 2008-08-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Thu | 2008-08-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Fri | 2008-08-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Sat | 2008-08-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Sun | 2008-08-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Mon | 2008-08-11 00:00:00 | 17:45:00 | 21:30:00 | 03:45:00 |  | 17:30:00 | 20:45:00 | 03:15:00 |  | 00:45:00 | 04:00:00 | 2.5 | 1.5 | 30.625
Tue | 2008-08-12 00:00:00 | 17:45:00 | 21:30:00 | 03:45:00 |  | 17:30:00 | 20:45:00 | 03:15:00 |  | 00:45:00 | 04:00:00 | 2.5 | 1.5 | 30.625
Wed | 2008-08-13 00:00:00 | 17:45:00 | 21:30:00 | 03:45:00 |  | 17:30:00 | 20:45:00 | 03:15:00 |  | 00:45:00 | 04:00:00 | 2.5 | 1.5 | 30.625
Thu | 2008-08-14 00:00:00 | 17:45:00 | 21:30:00 | 03:45:00 |  | 17:30:00 | 20:45:00 | 03:15:00 |  | 00:45:00 | 04:00:00 | 2.5 | 1.5 | 30.625
Fri | 2008-08-15 00:00:00 | 17:45:00 | 21:30:00 | 03:45:00 |  | 17:30:00 | 20:45:00 | 03:15:00 |  | 00:45:00 | 04:00:00 | 2.5 | 1.5 | 30.625
Sat | 2008-08-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Sun | 2008-08-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | 18:45:00 |  |  |  | 16:15:00 |  | 03:45:00 | 20:00:00 | 87.5 | 65.625 | 153.125
Mon | 2008-08-18 00:00:00 | 18:00:00 | 21:15:00 | 03:15:00 |  | 17:30:00 | 20:45:00 | 03:15:00 |  | 00:30:00 | 03:45:00 | 2.5 | 1.25 | 28.4375
Tue | 2008-08-19 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
Wed | 2008-08-20 00:00:00 | 17:00:00 | 21:00:00 | 04:00:00 |  | 17:30:00 | 20:45:00 | 03:15:00 |  | 00:45:00 | 04:00:00 | 3 | 1 | 29.75
Thu | 2008-08-21 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
Fri | 2008-08-22 00:00:00 | 17:00:00 | 20:45:00 | 03:45:00 |  | 17:30:00 | 20:45:00 | 03:15:00 |  | 00:30:00 | 03:45:00 | 3 | 0.75 | 27.5625
Sat | 2008-08-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Sun | 2008-08-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | 20:00:00 |  |  |  | 16:15:00 |  | 04:15:00 | 20:30:00 | 101.5 | 52.5 | 154
Mon | 2008-08-25 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.5 | 0 | 17.5
Tue | 2008-08-26 00:00:00 | 17:00:00 | 21:15:00 | 04:15:00 |  | 17:30:00 | 20:45:00 | 03:15:00 |  | 01:00:00 | 04:15:00 | 3 | 1.25 | 31.9375
Wed | 2008-08-27 00:00:00 | 17:00:00 | 20:45:00 | 03:45:00 |  | 17:30:00 | 20:45:00 | 03:15:00 |  | 00:30:00 | 03:45:00 | 3 | 0.75 | 27.5625
Thu | 2008-08-28 00:00:00 | 17:00:00 | 21:45:00 | 04:45:00 |  | 17:30:00 | 20:45:00 | 03:15:00 |  | 01:30:00 | 04:45:00 | 3 | 1.75 | 36.3125
Fri | 2008-08-29 00:00:00 | 17:00:00 | 20:45:00 | 03:45:00 |  | 17:30:00 | 20:45:00 | 03:15:00 |  | 00:30:00 | 03:45:00 | 3 | 0.75 | 27.5625
Sat | 2008-08-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Sun | 2008-08-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | 19:45:00 |  |  |  | 16:15:00 |  | 03:30:00 | 19:45:00 | 101.5 | 39.375 | 140.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 448