"Sean" wrote:

ok heres my problem

i have a sheet working out my wages (only an est.) but it does most of the
math for me ie tax payment, total with over time without deductions etc BUT i
want the over time cell to work out my overtime rate ONLY if the total hour
sheet and the total hour cell minues lunch break cell read 40+ is this
possable or am i asking to much off the spred sheet? (this saves data input
in the long run)


oh here are my formulas

=SUM(D16:D20) <<total hours
=SUM(E16:E20) << total hours after lunch break removed
=SUM(B23-40) << Overtime hours worked out from formula above
=SUM(B25*10.5) << overtime pay from hours worked out by overtime hour formula

as you can tell im very limited with exel