# multiply total hours by hourly pay

1. ## 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. 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

3. ## 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. Thank you BearAcade..... that's exactly what I was looking for! Thanks guys for the super fast help!
charitydc

#### Thread Information

##### Users Browsing this Thread

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

#### 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