Results 1 to 5 of 5
  1. #1
    dbrohm
    Guest

    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. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mulitiplying hours X dollars

    Don,

    you probablky have the right answer but the wrong formatting.

    Format your target cell as currency.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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.
    Legare Coleman

  4. #4
    dbrohm
    Guest

    Re: mulitiplying hours X dollars

    Thanks much, your formual worked!

    Don

  5. #5
    dbrohm
    Guest

    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
  •