Excel help (time and 1/2)
 

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

-Help would be appreciated-:)


--
User Name:
------------------------------------------------------------------------
User Name:'s Profile: http://www.excelforum.com/member.php...o&userid=33845
View this thread: http://www.excelforum.com/showthread...hreadid=536225

Excel help (time and 1/2)
 

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


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=536225

Excel help (time and 1/2)
 

Thanks a lot it worked great. :cool:


--
User Name:
------------------------------------------------------------------------
User Name:'s Profile: http://www.excelforum.com/member.php...o&userid=33845
View this thread: http://www.excelforum.com/showthread...hreadid=536225

Excel help (time and 1/2)
 

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"User Name:" wrote
in message ...

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

-Help would be appreciated-:)


--
User Name:
------------------------------------------------------------------------
User Name:'s Profile:
http://www.excelforum.com/member.php...o&userid=33845
View this thread: http://www.excelforum.com/showthread...hreadid=536225