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 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?

[Stefi]

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
>
>

[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=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

[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