+ Reply to Thread
Results 1 to 4 of 4

multiply total hours by hourly pay

  1. #1
    Registered User
    Join Date
    06-22-2006
    Location
    NW Florida
    MS-Off Ver
    Microsoft Office 2010
    Posts
    7

    multiply total hours by hourly pay

    I'm trying to figure out what the formula is to multiply the total hours worked per week by their hourly pay for each individual. kind of like the
    =Sum(I25:I32) Formula but I want to multiply the outcome of that formula by the hourly rate of 11.00, 15.00 and 16.00. Does anybody know how this can be done? If so I would greatly appreciate it.
    Thanks!
    charitydc

  2. #2
    Forum Contributor
    Join Date
    06-01-2006
    Posts
    324
    That depends where the cell you have set up with the pay...

    If I25:I32 is the hours, and let's say I5 is the hourly rate, you can do:

    =Sum(I25:I32)*I5
    Google is your best friend!

  3. #3
    Ardus Petus
    Guest

    Re: multiply total hours by hourly pay

    If I25:I32 holds hours expressed in Excel units, you must multiply by 24:
    =SUM(I25:I32)*24*I5

    HTH
    --
    AP

    "Bearacade" <Bearacade.29td7b_1150996802.2684@excelforum-nospam.com> a écrit
    dans le message de news:
    Bearacade.29td7b_1150996802.2684@excelforum-nospam.com...
    >
    > That depends where the cell you have set up with the pay...
    >
    > If I25:I32 is the hours, and let's say I5 is the hourly rate, you can
    > do:
    >
    > =Sum(I25:I32)*I5
    >
    >
    > --
    > Bearacade
    >
    >
    > ------------------------------------------------------------------------
    > Bearacade's Profile:
    > http://www.excelforum.com/member.php...o&userid=35016
    > View this thread: http://www.excelforum.com/showthread...hreadid=554658
    >




  4. #4
    Registered User
    Join Date
    06-22-2006
    Location
    NW Florida
    MS-Off Ver
    Microsoft Office 2010
    Posts
    7
    Thank you BearAcade..... that's exactly what I was looking for! Thanks guys for the super fast help!
    charitydc

+ 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