software

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: www.excelforum.com/member.php...oamp;userid=33845
View this thread: www.excelforum.com/showthread...hreadid=536225
=IF(A1gt;40,(A1-40)*12.5*1.5 40*12.5,A1*12.5)
This should work--
davesexcel------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=536225
Thanks a lot it worked great. --
User Name:
------------------------------------------------------------------------
User Name:'s Profile: www.excelforum.com/member.php...oamp;userid=33845
View this thread: www.excelforum.com/showthread...hreadid=536225=A1*12.5 MAX(A1-40,0)*12.5*0.5

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;User Name:quot; gt; wrote
in message ...
gt;
gt; Im new to Excel and was wondering how to do time and a half for any
gt; hours over 40. Lets say A1 is the hours they worked (say 60) and in A2
gt; was the amount earned (say at $12.50/hr) how I calculate the first
gt; 40hrs at $12.50 and then any hours after that at $12.50 times 1.5
gt;
gt; -Help would be appreciated-
gt;
gt;
gt; --
gt; User Name:
gt; ------------------------------------------------------------------------
gt; User Name:'s Profile:
www.excelforum.com/member.php...oamp;userid=33845
gt; View this thread: www.excelforum.com/showthread...hreadid=536225
gt;