Excel help (time and 1/2)

[User Name:]

Im new to Excel and was wondering how to do time and a half for an
hours over 40. Lets say A1 is the hours they worked (say 60) and in A
was the amount earned (say at $12.50/hr) how I calculate the firs
40hrs at $12.50 and then any hours after that at $12.50 times 1.5

-Help would be appreciated-:

 

[davesexcel]

=IF(A1>40,(A1-40)*12.5*1.5+40*12.5,A1*12.5)
This should work

 

[User Name:]

Thanks a lot it worked great.

 

[Bob Phillips]

=A1*12.5+MAX(A1-40,0)*12.5*0.5

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)