Multiplying time values and numbers

[bunnyc]

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 bay rate. This works okay
if there are no minutes involved (10:35). What formula would I use to
get the results I need?

 

[Guest]

Hi bunnyc,

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

Regards,
Stefi


„bunnyc†ezt írta:

 

[bunnyc]

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=Gros
pay

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


Bunn

 

[Pete_UK]

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