Hello
I would like to sum the total hours in Sheet1 Column I based on data from Sheet2 where each shift is listed with the amount of hours. I managed to do this with a helper worksheet but I'm sure there's an easier and faster way.
I would like to sum the total hours in Sheet1 Column I based on data from Sheet2 where each shift is listed with the amount of hours. I managed to do this with a helper worksheet but I'm sure there's an easier and faster way.
Sheet1 | A | B | C | D | E | F | G | H | I |
1 | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | SUNDAY | TOTAL | |
2 | Name1 | Warehouse 0600-1400 | Warehouse 0600-1400 | Warehouse 0600-1400 | Extra 0900-1500 | Warehouse 0600-1400 | 38 | ||
3 | Name2 | Warehouse 0600-1400 | Warehouse 0600-1400 | Warehouse 0600-1400 | 24 | ||||
4 | Name3 | Reception 0800-1300 | Reception 0800-1300 | Reception 0800-1300 | Reception 0800-1300 | Reception 0800-1300 | 25 | ||
5 | Name4 | Reception 1300-1700 | Reception 1300-1700 | Reception 1300-1700 | Reception 1300-1700 | Reception 1300-1700 | 20 |
Sheet2 | A | B |
1 | Warehouse 0600-1400 | 8 |
2 | Warehouse 1400-2200 | 8 |
3 | Warehouse 2200-0600 | 8 |
4 | Extra 0900-1500 | 6 |
5 | Reception 0800-1300 | 5 |
6 | Reception 1300-1700 | 4 |