Spreadsheet: 269442d1381161534-times-dont-add-up-team-hours1
Sheet: Sheet1

Week Commencing:-
Name | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday | Saturday | Total
 | Start | Finish | Start | Finish | Start | Finish | Start | Finish | Start | Finish
Worker 1 | 20:30:00 | 04:10:00 | 19:30:00 | 06:25:00 | 20:30:00 | 06:50:00 | 20:30:00 | 04:50:00 | 20:30:00 | 06:10:00 |  |  | 44.41666666666668
Worker 2 | 20:30:00 | 04:10:00 | 19:30:00 | 06:50:00 | 20:30:00 | 06:50:00 | 20:30:00 | 04:50:00 | 20:30:00 | 06:10:00 |  |  | 44.83333333333334
Worker 3 | 20:30:00 | 04:10:00 | 19:30:00 | 06:50:00 | 20:30:00 | 06:50:00 | 20:30:00 | 04:50:00 | 20:30:00 | 06:10:00 |  |  | 44.83333333333333
Worker 4 | 20:30:00 | 04:10:00 | 19:30:00 | 06:50:00 | 20:30:00 | 06:50:00 | 20:30:00 | 04:50:00 | 20:30:00 | 06:10:00 |  |  | 44.83333333333333
Worker 5 | 20:30:00 | 04:00:00 | 19:30:00 | 05:40:00 | 20:30:00 | 06:35:00 | 20:30:00 | 04:00:00 | 20:30:00 | 05:00:00 |  |  | 41.25
Worker 6 | 19:30:00 | 04:10:00 | 19:00:00 | 06:50:00 | 18:00:00 | 06:50:00 | 19:30:00 | 05:30:00 | 18:30:00 | 06:00:00 |  |  | 52.33333333333333
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | Total time includes deduction for 30 minute break
Total Hours Worked |  | Week Commencing:- |  |  | 1900-01-01 00:00:00
Name | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Total
Worker 1 | 07:10:00 | 10:25:00 | 09:50:00 | 07:50:00 | 09:10:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 44.41666666666668
Worker 2 | 07:10:00 | 10:50:00 | 09:50:00 | 07:50:00 | 09:10:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 44.83333333333334
Worker 3 | 07:10:00 | 10:50:00 | 09:50:00 | 07:50:00 | 09:10:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 44.83333333333333
Worker 4 | 07:10:00 | 10:50:00 | 09:50:00 | 07:50:00 | 09:10:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 44.83333333333333
Worker 5 | 07:00:00 | 09:40:00 | 09:35:00 | 07:00:00 | 08:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 41.25
Worker 6 | 08:10:00 | 11:20:00 | 12:20:00 | 09:30:00 | 11:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 52.33333333333333
0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0