Summing weekly hours, if suml of D48:D50 is = < 40 then leave blank, if >40 put the amt over 40 in cell - trying to calculate overtime hours on a weekly basis

TrY:=IF(SUM(D48:D50)<=40,"",SUM(D48:D50)-40)MIKEhttp://www.skeptic.com/

=IF(SUM(D48:D50)<=40,"",SUM(D48:D50)-40)

MIKE

http://www.skeptic.com/

Thanks a lot! Looks so simple when you see it!