In S8 =MIN(40, SUM(E8:K8)
In T8 =MAX(0, SUM(E8:K8)-40)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"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