Assuming your values are in NUMBER (or GENERAL) format: ( 8 not 8:00)

Try these:

S8 = reg hours

=MIN(SUM(E8:K8),40)

T8 = OT hours

=MAX(SUM(E8:K8)-40,0)


--
Biff
Microsoft Excel MVP


"Bernie" wrote in message
...
I am calculating a 40 hour week payroll and need to lets say take data from
E8 thru K8 and have them add in S8 but if it goes over 40 to show only 40
and
the remainder in T8 whick would be overtime