Spreadsheet: 693608d1599056101-random-calculation-error-with-adding-and-subtracting-times-timesheet-problem
Sheet: Mar

March 2020
 |  |  | Hours worked |  |  |  |  | Total |  |  | Travel |  |  |  | Total |  |  | Adjustment | Adjusted total | Top-up | Total with top-up |  |  | Total hours |  |  |  |  |  | Overtime accrued
Date | Day | Day type | Morning |  | Afternoon |  | Private appointment |  |  |  | First travel |  | Second travel |  |  |  |  |  |  |  |  |  |  | Overall |  |  |  |  |  | Total
 |  |  | Start | Finish | Start | Finish |  |  |  |  | Start | Finish | Start | Finish |  |  |  |  |  |  |  |  |  | Total | Diff | Total | Diff | Total | Diff
2020-03-01 00:00:00 | Sun | Weekend
2020-03-02 00:00:00 | Mon | Working day | 09:20:00 | 15:25:00 |  |  |  |  | 02:00:00
2020-03-03 00:00:00 | Tue | Working day | 09:30:00 | 11:40:00 | 12:10:00 | 16:05:00 |  |  | 03:00:00
2020-03-04 00:00:00 | Wed | Working day | 09:50:00 | 13:20:00 | 13:30:00 | 16:20:00 |  |  | 02:30:00
2020-03-05 00:00:00 | Thu | Working day | 10:50:00 | 16:45:00 |  |  |  |  | 05:00:00
2020-03-06 00:00:00 | Fri | Working day | 09:40:00 | 15:45:00 |  |  |  |  | 03:30:00
2020-03-07 00:00:00 | Sat | Weekend
2020-03-08 00:00:00 | Sun | Weekend
2020-03-09 00:00:00 | Mon | Working day | 09:20:00 | 12:45:00 | 13:10:00 | 15:50:00 |  |  | 02:30:00
2020-03-10 00:00:00 | Tue | Working day | 09:45:00 | 15:50:00 |  |  |  |  | 03:00:00
2020-03-11 00:00:00 | Wed | Working day | 10:00:00 | 11:00:00 | 11:45:00 | 16:30:00 |  |  | 02:30:00
2020-03-12 00:00:00 | Thu | Working day | 09:50:00 | 13:00:00 | 13:30:00 | 16:55:00 |  |  | 00:30:00
2020-03-13 00:00:00 | Fri | Working day | 10:00:00 | 16:25:00 |  |  |  |  | 00:30:00
2020-03-14 00:00:00 | Sat | Weekend
2020-03-15 00:00:00 | Sun | Weekend
2020-03-16 00:00:00 | Mon | Working day | 09:00:00 | 10:00:00 | 12:30:00 | 17:20:00 |  |  | 04:00:00
2020-03-17 00:00:00 | Tue | Working day | 10:00:00 | 12:00:00 | 13:00:00 | 17:05:00 |  |  | 04:00:00
2020-03-18 00:00:00 | Wed | Working day | 09:50:00 | 14:30:00 | 18:00:00 | 19:30:00 |  |  | 03:30:00
2020-03-19 00:00:00 | Thu | Working day | 09:15:00 | 12:30:00 | 13:20:00 | 17:05:00 |  |  | 02:00:00
2020-03-20 00:00:00 | Fri | Working day | 09:40:00 | 13:30:00 | 14:00:00 | 16:40:00 |  |  | 01:00:00
2020-03-21 00:00:00 | Sat | Weekend
2020-03-22 00:00:00 | Sun | Weekend
2020-03-23 00:00:00 | Mon | Working day | 09:30:00 | 12:40:00 | 15:40:00 | 18:00:00 |  |  | 02:00:00
2020-03-24 00:00:00 | Tue | Working day | 09:30:00 | 12:40:00 | 14:45:00 | 17:30:00 |  |  | 00:00:00
2020-03-25 00:00:00 | Wed | Working day | 09:40:00 | 13:15:00 | 15:40:00 | 18:05:00 |  |  | 02:00:00
2020-03-26 00:00:00 | Thu | Working day | 09:10:00 | 13:30:00 | 15:00:00 | 17:45:00 | 01:00:00 |  | 03:00:00
2020-03-27 00:00:00 | Fri | Working day | 10:00:00 | 13:00:00 | 14:15:00 | 18:00:00 |  |  | 00:20:00
2020-03-28 00:00:00 | Sat | Weekend
2020-03-29 00:00:00 | Sun | Weekend
2020-03-30 00:00:00 | Mon | Working day | 09:45:00 | 13:40:00 | 16:05:00 | 18:20:00 |  |  | 01:30:00
2020-03-31 00:00:00 | Tue | Working day | 10:00:00 | 13:10:00 | 16:10:00 | 18:25:00 |  |  | 01:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To carry forward:
 |  | Signatures
 |  | Employee |  |  |  |  |  | For ALLEA
 |  | Date |  |  |  |  |  | Date
 |  |  |  |  |  |  |  |  | (type name here)
 |  |  |  |  |  |  |  |  | (type job title here)