Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel help (time and 1/2)
Thanks a lot it worked great. -- 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|