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)

"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

I'm assuming you have hours in decimal format not time format.....

If you change your 3rd formula to

=MAX(B23-40,0)

then when B23 is less than 40 the result of this formula will be zero
so the next formula...

=SUM(B25*10.5)

will also return a zero.

In that last formula you don't need the SUM function, this will
suffice

=B25*10.5


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=528884

Change

=SUM(B23-40)

to

=MAX(B23-40,0)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Sean" wrote in message
...


"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

thanks guys big big big help