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

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