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

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