I have a spreadsheet that calculates regular hours and overtime hours. I
formatted my times [hh]:mm. What forula would I use to calculate total
pay. I tried A2*B2*24. A:hours worked and b:pay rate. This works okay
if there are no minutes involved (10:35). What formula would I use to
get the results I need?


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

Hi bunnyc,

Give an example of your problem! As I can see, there is no problem with your
formula!

Regards,
Stefi


€žbunnyc€� ezt Ã*rta:


I have a spreadsheet that calculates regular hours and overtime hours. I
formatted my times [hh]:mm. What forula would I use to calculate total
pay. I tried A2*B2*24. A:hours worked and b:pay rate. This works okay
if there are no minutes involved (10:35). What formula would I use to
get the results I need?


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

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

In arriving at the figure you think it should be, you have taken 10x40
+ 15*15.45, whereas you should have taken 10x40 + 15x15.75, as 45
minutes is .75 hours. The formula works fine and gives the correct
answer (checked on a calculator).

Hope this helps.

Pete