Excellent, Thanks for the help and explainations!

"mphell0" wrote:


I am assuming that everyone with a "T" gets triple time for all hours of
overtime instead of everything but the first two hours. If that is the
case then the formula would look like this:

=IF(B3="R",IF(A32,((A3-2)*2)+3,A3*1.5),IF(B3="D",A3*2,IF(B3="T",A3*3,"FAL SE")))

If you need to add anything else just replace the "FALSE" with an IF
statement similar to the other ones.


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=498319