+ Reply to Thread
Results 1 to 6 of 6

how to multiply h:mm value by an hourly $ rate

  1. #1
    Johstra
    Guest

    how to multiply h:mm value by an hourly $ rate

    Entering time values in custom format [h]:mm:ss
    Cells accept hours over 23,
    Adding cells in column returns correct total time.
    Have not found a way to multiply these cells by a $ hourly rate.
    So use HOUR(cell ref) and MINUTE(cell ref) to capture values in referenced
    cell - then use these values to calculate total payment for $rate per hour.
    However, the HOUR(cell ref) formula returns the hours in excess of 24 when
    the cell contains an hour value in excess of 23 (ie 27 hours returns 3).


  2. #2
    Forum Contributor
    Join Date
    01-05-2004
    Location
    Helsinki, Finland
    Posts
    100
    Hi,

    Excel uses decimal numbers to represent date/time. The integer part is the number of days starting from 1/1/1900 and the decimal part is a fraction of a day. I.e. 0.5 means 12 hours and in your example 27 hours = 1.125.

    Now let's say you use an hour rate of $20 and you have to calculate it for 27 hours. Use the following formula:

    =<time>*<rate>*24 => =<27 h>*<$20>*24 => =1.125*20*24 = $540

    Just remember to reformat the cell where the answer will be.

    - Asser

  3. #3
    Aladin Akyurek
    Guest

    Re: how to multiply h:mm value by an hourly $ rate

    =TotalTime*24*HourlyRate

    Johstra wrote:
    > Entering time values in custom format [h]:mm:ss
    > Cells accept hours over 23,
    > Adding cells in column returns correct total time.
    > Have not found a way to multiply these cells by a $ hourly rate.
    > So use HOUR(cell ref) and MINUTE(cell ref) to capture values in referenced
    > cell - then use these values to calculate total payment for $rate per hour.
    > However, the HOUR(cell ref) formula returns the hours in excess of 24 when
    > the cell contains an hour value in excess of 23 (ie 27 hours returns 3).
    >


  4. #4
    barnabel
    Guest

    RE: how to multiply h:mm value by an hourly $ rate

    try =(DAY(A6)*24+HOUR(A6)+MINUTE(A6)/60)*HR


    "Johstra" wrote:

    > Entering time values in custom format [h]:mm:ss
    > Cells accept hours over 23,
    > Adding cells in column returns correct total time.
    > Have not found a way to multiply these cells by a $ hourly rate.
    > So use HOUR(cell ref) and MINUTE(cell ref) to capture values in referenced
    > cell - then use these values to calculate total payment for $rate per hour.
    > However, the HOUR(cell ref) formula returns the hours in excess of 24 when
    > the cell contains an hour value in excess of 23 (ie 27 hours returns 3).
    >


  5. #5
    Registered User
    Join Date
    04-14-2014
    Location
    Tehran, Iran
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: how to multiply h:mm value by an hourly $ rate

    =(time-int(time))*24

  6. #6
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: how to multiply h:mm value by an hourly $ rate

    Try this, A1 is time
    =int(A1*24)*hourrate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1