calculating payroll

[Guest]

I need the formula to calculate hours into dollars.
For instance, here is the format for hours. [h]:mm
When I try to calculate how much money that is, it doesn't come out right.
so lets say that a1 is 80:00, using the format listed above,
Then B1 should be A18*10.00(rate of pay per hour)
When I do the obvious, A1*10.00 it comes up with $33.33. Thats obviously
not right. What format is the answer box supposed to be to calculate right?

 

[Biff]

Hi!

Try this:

total_hours * 24 * hourly_rate

=A1*24*10

Biff

 

[Biff]

P.S.

Format the formula cell as GENERAL or NUMBER

Biff

Hi!

Try this:

total_hours * 24 * hourly_rate

=A1*24*10

Biff

I need the formula to calculate hours into dollars.
For instance, here is the format for hours. [h]:mm
When I try to calculate how much money that is, it doesn't come out
right.
so lets say that a1 is 80:00, using the format listed above,
Then B1 should be A18*10.00(rate of pay per hour)
When I do the obvious, A1*10.00 it comes up with $33.33. Thats obviously
not right. What format is the answer box supposed to be to calculate
right?

 

[Guest]

=CONVERT(A1,"day","hr")*10

I believe excel is still treating A1 as a date (80 hours = Jan 3, 1900, 8:00
AM = 3.33 days) * 10 = 33.33