Spreadsheet: 794466d1662057105-calculating-attendance-times-from-shift-books-on-product-basis-2022-09-01-oeldere2-lena_mesta-excel-forum-attendances
Sheet: Hours worked

Employee | Item code | Date | Shift | Time | weeknumber | Time / day |  | Employees | Working days | Hours worked per week |  | 1 shift is | 7.5
13012 | 315802-01 | 2022-08-22 00:00:00 | 3 |  |  |  |  | 13012 | 2
13012 | 390119-01 | 2022-08-23 00:00:00 | 3 |  |  |  |  | 13219 | 6
13012 | 27527-01 | 2022-08-23 00:00:00 | 3 |  |  |  |  | 13319 | 2
13219 | 013202-01 | 2022-08-22 00:00:00 | 1 |  |  |  |  | 13918 | 5
13219 | 013202-01 | 2022-08-23 00:00:00 | 1 |  |  |  |  | 171610 | 2
13219 | 310250-01 | 2022-08-24 00:00:00 | 2 |  |  |  |  | 173512 | 4
13219 | 03372-01 | 2022-08-24 00:00:00 | 2 |  |  |  |  | 173600 | 2
13219 | 318127-01 | 2022-08-25 00:00:00 | 2 |  |  |  |  | 175200 | 5
13219 | 03372-01 | 2022-08-25 00:00:00 | 2 |  |  |  |  | 175212 | 2
13219 | 017639-01 | 2022-08-26 00:00:00 | 2 |  |  |  |  | 175310 | 6
13219 | 03372-02 | 2022-08-26 00:00:00 | 2 |  |  |  |  | 175710 | 2
13219 | 012960-01 | 2022-08-27 00:00:00 | 2 |  |  |  |  | 176211 | 5
13319 | 310808-01 | 2022-08-22 00:00:00 | 3 |  |  |  |  | 176500 | 1
13319 | 310250-01 | 2022-08-23 00:00:00 | 3 |  |  |  |  | 176700 | 5
13319 | 48386 | 2022-08-23 00:00:00 | 3 |  |  |  |  | 178410 | 2
13918 | 10221346-01 | 2022-08-22 00:00:00 | 2 |  |  |  |  | 178811 | 4
13918 | 27527-01 | 2022-08-23 00:00:00 | 2 |  |  |  |  | 183900 | 6
13918 | 939581 | 2022-08-24 00:00:00 | 3 |  |  |  |  | 184311 | 5
13918 | 10204973-01 | 2022-08-24 00:00:00 | 3 |  |  |  |  | 184312 | 3
13918 | 27616-01 | 2022-08-24 00:00:00 | 3 |  |  |  |  | 293200 | 1
13918 | 24413 | 2022-08-25 00:00:00 | 3 |  |  |  |  | 293372 | 5
13918 | 938910 | 2022-08-26 00:00:00 | 3 |  |  |  |  | 293373 | 6
13918 | 24413 | 2022-08-26 00:00:00 | 3 |  |  |  |  | 293382 | 5
171610 | 013202-01 | 2022-08-22 00:00:00 | 3 |  |  |  |  | 293383 | 5
171610 | 03372-01 | 2022-08-23 00:00:00 | 3 |  |  |  |  | sum of working days
171610 |  | 2022-08-23 00:00:00 | 3
171610 | 013202-01 | 2022-08-23 00:00:00 | 3
173512 | 310808-01 | 2022-08-22 00:00:00 | 2
173512 | 48386 | 2022-08-23 00:00:00 | 2
173512 | 310261-01 | 2022-08-23 00:00:00 | 2
173512 | 310808-01 | 2022-08-23 00:00:00 | 2
173512 | 310250-01 | 2022-08-24 00:00:00 | 3
173512 | 318127-01 | 2022-08-25 00:00:00 | 3
173512 | 314066-01 | 2022-08-26 00:00:00 | 3
173512 |  | 2022-08-26 00:00:00 | 3
173600 | 10204964-01 | 2022-08-22 00:00:00 | 3
173600 | 210384-01 | 2022-08-22 00:00:00 | 3
173600 | 210478-01 | 2022-08-23 00:00:00 | 3
175200 | 939703 | 2022-08-22 00:00:00 | 2
175200 | 29929-01 | 2022-08-23 00:00:00 | 2
175200 | 939703 | 2022-08-24 00:00:00 | 3
175200 | 939703 | 2022-08-24 00:00:00 | 3
175200 | 939703 | 2022-08-25 00:00:00 | 3
175200 | 939703 | 2022-08-26 00:00:00 | 3
175212 | 939581 | 2022-08-24 00:00:00 | 2
175212 | 27616-01 | 2022-08-25 00:00:00 | 2
175212 | 24413 | 2022-08-25 00:00:00 | 2
175310 | 212331-01 | 2022-08-22 00:00:00 | 1
175310 | 10204964-01 | 2022-08-23 00:00:00 | 1
175310 |  | 2022-08-23 00:00:00 | 1
175310 | 210478-01 | 2022-08-24 00:00:00 | 2
175310 | 938883 | 2022-08-24 00:00:00 | 2
175310 | 10202734-01 | 2022-08-25 00:00:00 | 2
175310 | 10202734-01 | 2022-08-26 00:00:00 | 2
175310 | 30516/17 | 2022-08-27 00:00:00 | 2
175310 | 116376-01 | 2022-08-27 00:00:00 | 2
175710 | 111742-01 | 2022-08-22 00:00:00 | 3
175710 | 115128-01 | 2022-08-23 00:00:00 | 3
175710 | 115127-01 | 2022-08-23 00:00:00 | 3
176211 | 013202-01 | 2022-08-22 00:00:00 | 2
176211 | 013202-01 | 2022-08-23 00:00:00 | 2
176211 | 03372-01 | 2022-08-24 00:00:00 | 3
176211 | 03372-01 | 2022-08-25 00:00:00 | 3
176211 | 017639-01 | 2022-08-26 00:00:00 | 3
176500 | 116376-01 | 2022-08-28 00:00:00 | 3
176700 | 210384-01 | 2022-08-22 00:00:00 | 2
176700 | 212331-01 | 2022-08-22 00:00:00 | 2
176700 | 210478-01 | 2022-08-23 00:00:00 | 2
176700 | 10204964-01 | 2022-08-23 00:00:00 | 2
176700 | 938883 | 2022-08-24 00:00:00 | 3
176700 | 938883 | 2022-08-24 00:00:00 | 3
176700 | 10202734-01 | 2022-08-25 00:00:00 | 3
176700 | 212686-01 | 2022-08-26 00:00:00 | 3
176700 | 10202734-01 | 2022-08-26 00:00:00 | 3
178410 | 939703 | 2022-08-22 00:00:00 | 3
178410 | 29929-01 | 2022-08-22 00:00:00 | 3
178410 | 29929-01 | 2022-08-23 00:00:00 | 3
178811 | 29929-01 | 2022-08-24 00:00:00 | 1
178811 | 939703 | 2022-08-25 00:00:00 | 1
178811 | 939703 | 2022-08-26 00:00:00 | 1
178811 | 10219225-01 | 2022-08-28 00:00:00 | 3
178811 | 10204969/70-01 | 2022-08-28 00:00:00 | 3
183900 | 938823-01 | 2022-08-22 00:00:00 | 1
183900 | 115127-01 | 2022-08-23 00:00:00 | 1
183900 | 111742-01 | 2022-08-23 00:00:00 | 1
183900 | 214827-01 | 2022-08-24 00:00:00 | 2
183900 | 26935-01 | 2022-08-25 00:00:00 | 2
183900 | 26935-01 | 2022-08-26 00:00:00 | 2
183900 | 214828-01 | 2022-08-27 00:00:00 | 2
184311 | 310250-01 | 2022-08-24 00:00:00 | 1
184311 | 939581 | 2022-08-24 00:00:00 | 1
184311 | 390119-01 | 2022-08-24 00:00:00 | 1
184311 | 938970 | 2022-08-25 00:00:00 | 1
184311 | 310250-01 | 2022-08-25 00:00:00 | 1
184311 | 27616-01 | 2022-08-25 00:00:00 | 1
184311 | 318127-01 | 2022-08-26 00:00:00 | 1
184311 | 24413 | 2022-08-26 00:00:00 | 1
184311 | 212686-01 | 2022-08-27 00:00:00 | 1
184311 | 939168 | 2022-08-28 00:00:00 | 3
184311 | 214799-02 | 2022-08-28 00:00:00 | 3
184312 | 210478-01 | 2022-08-24 00:00:00 | 1
184312 | 938883 | 2022-08-25 00:00:00 | 1
184312 | 10202734-01 | 2022-08-25 00:00:00 | 1
184312 | 10202734-01 | 2022-08-26 00:00:00 | 1
184312 | 10202734-01 | 2022-08-26 00:00:00 | 1
293200 | 214828-01 | 2022-08-27 00:00:00 | 2
293372 | 03372-01 | 2022-08-24 00:00:00 | 1
293372 | 03372-01 | 2022-08-25 00:00:00 | 1
293372 | 03372-02 | 2022-08-26 00:00:00 | 1
293372 | 03372-01 | 2022-08-26 00:00:00 | 1
293372 | 017639-01 | 2022-08-27 00:00:00 | 1
293372 | 012960-01 | 2022-08-27 00:00:00 | 1
293372 | 012960-01 | 2022-08-28 00:00:00 | 3
293373 | 310808-01 | 2022-08-22 00:00:00 | 1
293373 | 10205766-01 | 2022-08-22 00:00:00 | 1
293373 | 916391 | 2022-08-22 00:00:00 | 1
293373 | 10221346-01 | 2022-08-22 00:00:00 | 1
293373 | 939703 | 2022-08-22 00:00:00 | 1
293373 | 310808-01 | 2022-08-23 00:00:00 | 1
293373 | 211773-01 | 2022-08-23 00:00:00 | 1
293373 | 315802-01 | 2022-08-23 00:00:00 | 1
293373 | 29929-01 | 2022-08-23 00:00:00 | 1
293373 | 939703 | 2022-08-24 00:00:00 | 2
293373 | 29929-01 | 2022-08-24 00:00:00 | 2
293373 | 938970 | 2022-08-25 00:00:00 | 2
293373 | 939703 | 2022-08-25 00:00:00 | 2
293373 | 314066-01 | 2022-08-26 00:00:00 | 2
293373 | 318127-01 | 2022-08-26 00:00:00 | 2
293373 | 939703 | 2022-08-26 00:00:00 | 2
293373 | 939168 | 2022-08-27 00:00:00 | 2
293373 | 938910 | 2022-08-27 00:00:00 | 2
293373 | 939703 | 2022-08-27 00:00:00 | 2
293382 | 115128-01 | 2022-08-24 00:00:00 | 1
293382 | 26935-01 | 2022-08-25 00:00:00 | 1
293382 | 26935-01 | 2022-08-26 00:00:00 | 1
293382 |  | 2022-08-26 00:00:00 | 1
293382 | 214828-01 | 2022-08-27 00:00:00 | 1
293382 | 214828-01 | 2022-08-28 00:00:00 | 3
293382 | 214828-01 | 2022-08-28 00:00:00 | 3
293383 | 111742-01 | 2022-08-22 00:00:00 | 2
293383 | 938823-01 | 2022-08-22 00:00:00 | 2
293383 | 115127-01 | 2022-08-23 00:00:00 | 2
293383 | 26935-01 | 2022-08-24 00:00:00 | 3
293383 | 214827-01 | 2022-08-24 00:00:00 | 3
293383 | 26935-01 | 2022-08-25 00:00:00 | 3
293383 | 26935-01 | 2022-08-25 00:00:00 | 3
293383 | 26935-01 | 2022-08-25 00:00:00 | 3
293383 | 214828-01 | 2022-08-26 00:00:00 | 3
293383 | 26935-01 | 2022-08-26 00:00:00 | 3
 |  | 2022-08-26 00:00:00 | 2
 |  | 2022-08-27 00:00:00 | 1
 |  | 2022-08-27 00:00:00 | 2
 |  | 2022-08-27 00:00:00 | 1
 |  | 2022-08-27 00:00:00 | 1
 |  | 2022-08-28 00:00:00 | 3