Need help with simple timesheet formula

[SeanC1970]

Sorry, my skills with excel are limited, but I'm sure this will be a simple formula for most. Here's what I have and what I'm trying to achieve.

Cells  A-E all have a value of "10", representing the total number of hours worked for each day.

Cell F shows that total of hours as "50" ... I'm using =sum(A1,B1,C1,D1,E1)

Cell G shows the total of OT hours as "10" ... =if(F1>40,F1-40,"")

I want cell F to show 40 and still have cell G to show 10.

[#2]

In cell F =IF(SUM(A1:E1)>40,40,SUM(A1:E1)) and in cell G =SUM(A1:E1)-F1 i guess this would solve your issue , if not please explain more in order for me to understand :)

[#3]

F1=MIN(SUM(A1:E1),40)
G1=SUM(A1:E1)-F1

[#4]

Both suggestions work. Thanks so very much. I'm still tweaking my sheet to best suit my needs, but now at least my numbers match.