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)

	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>

 

[jasonb75]

Try

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

 

[AdyStewart]

Thank you

That done the trick