simple formula help plz

[FCI2sue]

Hello
Need help with a formula that will return breakdown of weekly hours worked as Regular ( 40 hrs) and OT ( result of hours worked over 40)
But if worked less than 40 hours - then show actual hrs worked
and if no OT wasn't worked, then show a result of '0'
Thanks in advance for your help !

Sep-18			Reg	OT
CEASAR	M	T	W	T	F	S	S
wk 1	0	0	0	0	0	0	0	0	9/1 - 9/2
wk 2			10.15	11.68	9.3	8.58	0	39.71	9/3 - 9/9		`
wk 3			10.43	9.68	9.885	9.2		39.195	9/10 -9/16
wk 4								0	9/17 - 9/23
wk 5								0	9/24 - 9/30
								78.905

<colgroup><col width="64" style="width: 48pt;" span="13"> <tbody> </tbody>

 

[Joe4]

Let's say that the days are in the cells B3-H3.

Then the regular hours would be:
=MIN(SUM(B3:H3),40)

and the overtime hours would be:
=MAX(SUM(B3:H3)-40,0)

 

[FCI2sue]

works perfectly
thanks so much for your help and super quick response !

 

[Joe4]

You are welcome!
Glad I was able to help.