Hello,
I am stumped on a roster I have been working on. There are several types of shifts for the workers, A, DD, S12 and so on. Each of those shifts has a numeric value, eg. DD = a 10 hour shift. So I'm guessing I need a table as a lookup reference like so?
<tbody>
</tbody>
When I type in the Shift Codes in B2, B3 and B5 for example, I'd like B9 to show the total hours worked for Bob as a number. I'm having a hard time working out the formula that works best for this situation. Any guidance would be greatly appreciated. Thank you.
<tbody>
</tbody>
I am stumped on a roster I have been working on. There are several types of shifts for the workers, A, DD, S12 and so on. Each of those shifts has a numeric value, eg. DD = a 10 hour shift. So I'm guessing I need a table as a lookup reference like so?
Shift Code | Hours |
A | 8 |
DD | 10 |
S12 | 12 |
<tbody>
</tbody>
When I type in the Shift Codes in B2, B3 and B5 for example, I'd like B9 to show the total hours worked for Bob as a number. I'm having a hard time working out the formula that works best for this situation. Any guidance would be greatly appreciated. Thank you.
A | B | C | D | E | |
1 | Day | Bob | Max | Edy | Gav |
2 | Mon | A | E | S12 | D |
3 | Tue | DD | DD | A | E |
4 | Wed | ||||
5 | Thurs | S12 | |||
6 | Fri | ||||
7 | Sat | ||||
8 | Sun | ||||
9 | 30 | 15 | 20 | 10 |
<tbody>
</tbody>
Last edited: