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

April 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-04-01 00:00:00 | Wed | Working day | 09:50:00 | 13:30:00 | 16:00:00 | 18:50:00 |  |  | 02:00:00
2020-04-02 00:00:00 | Thu | Working day | 09:30:00 | 13:25:00 | 15:30:00 | 19:30:00 |  |  | 04:00:00
2020-04-03 00:00:00 | Fri | Working day | 10:40:00 | 13:00:00 | 14:40:00 | 19:00:00 |  |  | 02:40:00
2020-04-04 00:00:00 | Sat | Weekend
2020-04-05 00:00:00 | Sun | Weekend
2020-04-06 00:00:00 | Mon | Working day | 10:20:00 | 14:20:00 | 16:40:00 | 18:35:00 |  |  | 03:55:00
2020-04-07 00:00:00 | Tue | Working day | 10:20:00 | 13:40:00 | 16:00:00 | 18:00:00 |  |  | 03:00:00
2020-04-08 00:00:00 | Wed | Working day | 09:40:00 | 11:40:00 | 14:00:00 | 18:30:00 | 01:15:00 |  | 03:15:00
2020-04-09 00:00:00 | Thu | Working day | 09:30:00 | 13:00:00 | 16:30:00 | 18:30:00 |  |  | 04:00:00
2020-04-10 00:00:00 | Fri | Working day | 10:00:00 | 13:50:00 | 18:00:00 | 19:00:00 |  |  | 03:00:00
2020-04-11 00:00:00 | Sat | Weekend
2020-04-12 00:00:00 | Sun | Weekend
2020-04-13 00:00:00 | Mon | Public holiday
2020-04-14 00:00:00 | Tue | Working day | 09:00:00 | 12:00:00 | 13:45:00 | 17:00:00 |  |  | 03:00:00
2020-04-15 00:00:00 | Wed | Working day | 09:30:00 | 13:15:00 | 16:25:00 | 18:50:00 |  |  | 00:30:00
2020-04-16 00:00:00 | Thu | Working day | 08:30:00 | 11:50:00 | 13:30:00 | 16:15:00 |  |  | 01:30:00
2020-04-17 00:00:00 | Fri | Working day | 09:50:00 | 13:35:00 | 16:45:00 | 19:05:00 |  |  | 00:30:00
2020-04-18 00:00:00 | Sat | Weekend
2020-04-19 00:00:00 | Sun | Weekend
2020-04-20 00:00:00 | Mon | Working day | 09:30:00 | 13:30:00 | 17:10:00 | 18:55:00 |  |  | 02:00:00
2020-04-21 00:00:00 | Tue | Working day | 09:10:00 | 12:30:00 | 13:30:00 | 18:40:00 | 02:45:00 |  | 01:00:00
2020-04-22 00:00:00 | Wed | Annual leave
2020-04-23 00:00:00 | Thu | Working day | 09:40:00 | 13:30:00 | 16:45:00 | 18:50:00 |  |  | 01:00:00
2020-04-24 00:00:00 | Fri | Working day | 09:40:00 | 14:40:00 | 18:00:00 | 19:50:00 |  |  | 02:00:00
2020-04-25 00:00:00 | Sat | Weekend
2020-04-26 00:00:00 | Sun | Weekend
2020-04-27 00:00:00 | Mon | Sick leave
2020-04-28 00:00:00 | Tue | Working day | 09:20:00 | 12:30:00 | 13:40:00 | 16:20:00 |  |  | 02:30:00
2020-04-29 00:00:00 | Wed | Working day | 09:10:00 | 13:15:00 | 14:10:00 | 16:20:00 | 00:40:00 |  | 00:40:00
2020-04-30 00:00:00 | Thu | Sick leave
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To carry forward:
 |  | Signatures
 |  | Employee |  |  |  |  |  | For ALLEA
 |  | Date | 7.05.2020 |  |  |  |  | Date
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Executive Director