In S8 type in

=IF(Sum(E8:K8)<40,Sum(E8:K8),40)

in T8 type

=IF(Sum(E8:K8)40,Sum(e8:k8)-40,0)

See if that works

"Bernie" wrote:

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