# Thread: mulitiplying hours X dollars

1. ## mulitiplying hours X dollars

I would like to know how to multiply an hour by a dollar amount in excel? This would be to calculate an amount when you know the number of hour and the hourly rate.

Example:

cell contains time amount, i.e. 3:00
how do you mulitiple this cell by the rate per hour, i.e. 18 and get a result of 54?

Thanks
Don Brohm

2. ## Re: mulitiplying hours X dollars

Don,

you probablky have the right answer but the wrong formatting.

Format your target cell as currency.

3. ## Re: mulitiplying hours X dollars

Don: Date/Time in Excell are kept as the number of days since 12am 1/1/1900. Therefore, time is kept at the fractional part of one day (24 hours. Twelve hours = .5, six hours = .25, 3 hours = .125, etc. Therefore, you need to multiply the time by 24 to get the number of hours. If the time is in A1, and the rate is in A2, then the following formula should give you what you want:

=A1*24*A2

Make sure that the cell containing the time does not also contain a date. If it does, then you will need to use one of several methods to extract just the time that you want.

Don

5. ## Re: mulitiplying hours X dollars

Thanks for reply, formating the cell with the results as currency did not provide correct answer for me, but, the answer from LegareColeman worked!

If the time is in A1, and the rate is in A2, then the following formula should give you what you want:
=A1*24*A2

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•