calculating payroll
 

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?

calculating payroll
 

Hi!

Try this:

total_hours * 24 * hourly_rate

=A1*24*10

Biff

"TeddyBearDJ" wrote in message
...
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?

calculating payroll
 

P.S.

Format the formula cell as GENERAL or NUMBER

Biff

"Biff" wrote in message
...
Hi!

Try this:

total_hours * 24 * hourly_rate

=A1*24*10

Biff

"TeddyBearDJ" wrote in message
...
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?

calculating payroll
 

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