multiply total hours by hourly pay

C

charitydc

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

Bearacade

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 ca
do:

=Sum(I25:I32)*I
 
A

Ardus Petus

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

HTH
 
C

charitydc

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate total for rate times hours in Excel? 3
using hours to multiply rate 2
Work hours with overtime 2
Simple Time sheet, calculate OT 2
How to calculate total cost using fixed hourly rate from [h:mm:ss:]? 4
Need to work hours backwards 10
multiply Hrs:Mins by £Hourly Pay 1
wages - multiply hours and minutes by number of hours worked 6

Top