Creating a Time Card with O/T

[Gregh13]

New to spreadsheets. I have created a bi weekly time card based only on hours worked (no clock in clock out fields). I have 3 columns for hours (the actual time worked per day, O/T per day and Reg Hours per day with the O/T subtracted.

What I can't figure out how to do is create a code so if total hours in one week equals 40 any additional hours worked get added straight to the O/T line.
(mon-Fri =40 so any work on Saturday gets added to O/T total. And if mon-fri only equals say 35 and I work 8 hours on saturday, 5 hours from saturday goes towards the regular 40 total and then other 3 goes to O/T total.

 

[Gregh13]

<img>https://drive.google.com/file/d/1C0xdp1GfmCyB0hEZGbL6u35RY1YpsaKD/view?usp=sharing</img>

 

[Gregh13]

nvm, my brother got it to work

 

[KLFT]

New to spreadsheets. I have created a bi weekly time card based only on hours worked (no clock in clock out fields). I have 3 columns for hours (the actual time worked per day, O/T per day and Reg Hours per day with the O/T subtracted.

What I can't figure out how to do is create a code so if total hours in one week equals 40 any additional hours worked get added straight to the O/T line.
(mon-Fri =40 so any work on Saturday gets added to O/T total. And if mon-fri only equals say 35 and I work 8 hours on saturday, 5 hours from saturday goes towards the regular 40 total and then other 3 goes to O/T total.

Greg, would you share your spreadsheet formulas? I have been trying to get the same results but, I'm not as savvy with formulas.