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?

Hi!

Try this:

total_hours * 24 * hourly_rate

=A1*24*10

Biff

"TeddyBearDJ" <(E-Mail Removed)> wrote in message
news:A2365C1E-1CF4-40A9-83AD-(E-Mail Removed)...
>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?
>

P.S.

Format the formula cell as GENERAL or NUMBER

Biff

"Biff" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi!
>
> Try this:
>
> total_hours * 24 * hourly_rate
>
> =A1*24*10
>
> Biff
>
> "TeddyBearDJ" <(E-Mail Removed)> wrote in message
> news:A2365C1E-1CF4-40A9-83AD-(E-Mail Removed)...
>>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?
>>
>
>

=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


"TeddyBearDJ" wrote:

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