A B C D E
40:00 15:45 $10.00 $15.00 $631.75

A = Reg. Hours B=Overtime Hours C=Reg. Rate D=Overtime Rate E=Gross
pay

I'm using the formula =(a1*c1)*24+(b1*d1)*24 to calculate the gross
pay. Using the formula the gross pay is $636.25, it should be $631.75.


Bunny


--
bunnyc
------------------------------------------------------------------------
bunnyc's Profile: http://www.excelforum.com/member.php...o&userid=31662
View this thread: http://www.excelforum.com/showthread...hreadid=513521