Working out Extra hours with a limit

[AdyStewart]

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)

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]D[/TD]
[TD]F[/TD]
[TD]H[/TD]
[TD]J[/TD]
[TD]L[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Name[/TD]
[TD]Contract Hours Per week[/TD]
[TD]W1 Hours[/TD]
[TD]W2 Hours[/TD]
[TD]W3 Hours[/TD]
[TD]W4 Hours[/TD]
[TD]Extra Hours PP[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]John Smith[/TD]
[TD]32[/TD]
[TD]35[/TD]
[TD]27[/TD]
[TD]38[/TD]
[TD]27[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Jane Smith[/TD]
[TD]32[/TD]
[TD]36[/TD]
[TD]27[/TD]
[TD]40[/TD]
[TD]28[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]John Doe[/TD]
[TD]32[/TD]
[TD]40[/TD]
[TD]40[/TD]
[TD]40[/TD]
[TD]45[/TD]
[TD]32[/TD]
[/TR]
</tbody>[/TABLE]

 

[jasonb75]

Try

=MAX(0,MIN(D2+F2+H2+J2,160)-(4*B2))

 

[AdyStewart]

Thank you

That done the trick