I am trying to make a time sheet that automatically calculates regular time
and overtime.

B C D E F

Time Worked Total Reg O/T
Start End Hours Hours Hours


In column E, I would like it to add up the total amount of regular hours
worked (up to 8 hours) on a given day. In column F I would like a total of
any hours over 8 hours in a given day.

Can someone help me with the formula for this.

Thanks