B C D E F
Time Worked Total Reg O/T
Start End Hour Hours Hours
8:00 17:00 9 8 1

D3 =(C3-B3)*24 Total hours
E3 =MIN(MAX(D3,0),8) Reg hours
F3 =MAX(D3-8,0) O/T hours



"Kevin" wrote:

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