time sheet

[KimC]

I have set up a time sheet for employees to fill out on the computer. I need
one column (STRAIGHT TIME) to total up to 8 hours ONLY, and anything beyond
that to go in the OVERTIME column. So in other words, if I work 10 hours in a
day, I need Excel to automatically record 8 hours in the straight time
column, and 2 hours in the overtime column. I can't find what formulas to use
to make this happen automatically upon entering the hours worked.

[mudraker]

This formula add a1 and b1. if sum value greater than 8 hours it shows 8 hours. other wise it shows total value of added cell.

0.3333334 is the numeric value for 08:00

=IF(SUM(A1:B1)>0.3333334,0.3333334,SUM(A1:B1))

This formula displays value greater than 8:00 munus 8:00

=IF(SUM(A1:B1)<0.3333334,"",SUM(A1:B1)-0.3333334)

[daddylonglegs]

If you already have a total number of hours worked each day in time format in cell D2, for instance then for straight time in E2

=IF(D2="","",MIN("08:00"+0,D2))

then in F2

=IF(E2="","",D2-E2)