AdyStewart
New Member
- Joined
- Jun 29, 2019
- Messages
- 6
OK i have been racking my brain about this for far too long, hopefully someone here can help me
What i need is a formula that will tell me how many extra hours someone has worked over their contracted hours,
So the Min would be their Contacted Hours Per Week * 4 (32*4=128) the Max would be 160
i would like this in One Formula if possible
Cells D2+F2+H2+J2 = 127 Extra hours = 0
Cells D3+F3+H3+J3 = 131 Extra hours = 3
Cells D4+F4+H4+J4 = 165 Extra hours = 32 (160-128=32)
<tbody>
</tbody>
What i need is a formula that will tell me how many extra hours someone has worked over their contracted hours,
So the Min would be their Contacted Hours Per Week * 4 (32*4=128) the Max would be 160
i would like this in One Formula if possible
Cells D2+F2+H2+J2 = 127 Extra hours = 0
Cells D3+F3+H3+J3 = 131 Extra hours = 3
Cells D4+F4+H4+J4 = 165 Extra hours = 32 (160-128=32)
A | B | D | F | H | J | L | |
1 | Name | Contract Hours Per week | W1 Hours | W2 Hours | W3 Hours | W4 Hours | Extra Hours PP |
2 | John Smith | 32 | 35 | 27 | 38 | 27 | 0 |
3 | Jane Smith | 32 | 36 | 27 | 40 | 28 | 3 |
4 | John Doe | 32 | 40 | 40 | 40 | 45 | 32 |
<tbody>
</tbody>