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


--
charitydc
------------------------------------------------------------------------
charitydc's Profile: http://www.excelforum.com/member.php...o&userid=35682
View this thread: http://www.excelforum.com/showthread...hreadid=554658

multiply total hours by hourly pay
 

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

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" a écrit
dans le message de news:
...

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

multiply total hours by hourly pay
 

Thank you BearAcade..... that's exactly what I was looking for! Thanks
guys for the super fast help!
charitydc


--
charitydc
------------------------------------------------------------------------
charitydc's Profile: http://www.excelforum.com/member.php...o&userid=35682
View this thread: http://www.excelforum.com/showthread...hreadid=554658