I assume that you will enter the start time and Worked End in Excel
time format, i.e. something like 8:00 and 17:00 respectively. If so,
then you will probably want to work in hours for the rest of the sheet,
so enter these formulae in the cells shown:

D2: =(C2-B2)*24
E2: =MIN(D2,8)
F2: =IF(D28,D2-8,0)

Format these three cells as number with 2 decimal places, then copy the
formulae down as required.

Hope this helps.

Pete

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