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.
Similar Excel Video Tutorials
Gross Pay and Overtime: 5 Examples
- Learn about:
1.Calculating Gross pay using the ROUND function
2.Overtime for over 40 hours worked in a week
3.Overtime for over 40 hour ...
Dang... the hardest part of trying to ask for help is trying to figure out how to say what you want to say!!!
I am trying to create a conditional formula. I have multiple workers that work for different $$ per hour. I am keeping the hourly rates on one page for security purposes (the person that is going to be updating the hours worked is not very computer savy and they less they have to type the better) and the hours on another... I want copy a formula down the page that will calculate the hours to the hourly rate. The issue is that i want the formula to look at all of the hourly rates (assume they get raises) for Joe and multiply the most recent hourly rate times the hours... in addition I don't want the formula to re-calculate when a new hourly rate is put into the hours sheet.
Jan. 1 joe works 8hours at $10 per hour formula in A1 (or wherever) calculates $80
Jan. 2 joe gets $1 raise
Jan. 2 Joe works 8 hours at $11 per hour formual in A2 calculates $88 but formula in A1 maintains the $80 and does not calculate the $1 raise.
Does this make sense???
Thanks for your help. If confused let me know and i will
This is what I want to do:
Want to input the amount of hours I work every day.
Add all the hours up for each week and multiply it by my hourly wage to figure out what my gross total is.
Then, for every $100, I want it to deduct a certain amount (to roughly estimate for taxes).
I know how to do the first two, but I don't know how to do the last part. Is that possible?
When I subtract 15:30 from 09:00, I get 6:30. But when i use this as hours worked and multiply it by an hourly rate, i get an inaccurate number. How do I accomplish this. I just want to be able to subtract an ending time from the beginning time and multiply it by an hourly rate.
doing a project spread sheet using custom format hh:mm to record volunteer
Problem 1 - volunteers who have contributed > 24 hours return the wrong
answer when hours totalled )i.e. seems to go back to zero when 24 hours
problem 2 how do I multiply the totla individual hours by the individual
hourly rates to obtain a total value?
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).
This is my second post and I thought I would ask a excel question.
I am making a sheet to keep track of man hours worked during the week.
I can format the cell to figure out hours worked for a day by Subtracting the end time from the start time +12.
Start 8, End 4, Total Hours worked 8 hours or = C7-B7+12 is 8 hours.
if I SUM the 5 cells I use for the amount of the five work days totals hours, AND it's over 40!! How do I
Get 1 through 40 hours to *hourly rate, and any overtime hours to *by 1.5 the hourly rate? (DISCLAIMER)I am very much a beginner so please go easy if it is at all possible.
THANKS for your help or even to be pointed in the right direction.
So, i have a table which is co-ordinating hours worked for my clients.
However, this has been generated into a box where i am using a hh:mm format.
I am then inputing an hourly rate and require a multiplication to take
place. As i have a different value for different clients, i need to be able
to input a number and this to be multiplied by the hours.
I am going crazy as the Excel help facility is either sending me round in
circles or giving me help which is no help at all.
I have 5 cells in a row with a different hourly rate across the top of the page.
I have 5 cells in a row below the hourly rate row with labor hours.
I want to total the labor hours for that row times the hourly rate and have it total like this.
Row 2 is the hourly rate.
Row 4 is the hours.
My question is when I paste this formula down the columns the row 2 increments.
I have a lot of rows and don't want to edit each formula.
Is there a way around this?
I've been working on this equation for a couple of hours now and just know that I'm missing something simple. Any help would be greatly appreciated.
Below is a section of the spreadsheet that I have created to calculate payouts under specific conditions. The payouts are all based on a weekly rate. However, all of our data is either an annual rate or an hourly rate and the user would be entering it in that way. The user would be entering either an annual or an hourly rate as appropriate under the applicable column, leaving the other column blank. I want to be able to put a single formula under the weekly rate that will calculate the weekly rate as appropriate and as per how the rate was entered.
For example - to calculate the weekly rate using an annual salary the formula is - $annual rate/52.18. Using an hourly rate the formula is $hourly rate * hours of work per week.
How can I incorporate both of these formulas into one, so that the user can enter the rate field as either annual or hourly and the formula will calculate the weekly rate.
Hours of Work
I have a problem with trying to figure up how much to pay a telemarketer for the week. Our payroll spreadsheet is right now set up to figure up an hourly rate and a commission for the week. Whichever is greater, the salesman gets paid that amount. I found out that actually we've been paying wrong. What should happen is this: if the hours worked > 40 AND the commission > hourly rate, then it should be ((commission/hours) * .5 * overtime hours) + commission, else if either one of those is false then it should pay the greater of the commission or the hourly rate. I need to come up with a foolproof formula that will get me this amount. If there is anyone who can help me, I would greatly appreciate it.
I'm hoping someone can help me. I am trying to build a formula that will determine an hourly wage. For example. If I make $1000.00 a week, and work 73.5 hours during that week, how can I create a formula that will determine for me the hourly rate up to 40 hours, and the overtime rate at 1.5X thereafter.....keeping taxes completely out of the picture. The only constant in the formula would be the $1000.00 per week, the hourly wage and overtime wage would constantly change depending on the hours worked for the week. Any help at all would definately be appreciated!
I am starting with a very simple spreadsheet just to figure out the mechanics.
As you can see, in B2 and B3 I have 2 time objects.
For normal Hours I have =D34+(B2>D34)-B2
For After Hours I have =B3+(D34>B3)-D34
Then as you can see I have a value of 3.50, which is a decimal conversion of the 3:30 hours using
But because this is still typically a time object, if I was to multiply it by an hourly rate, I will not be returned with the correct pay.
What I need is to figure out a way to make that 3.5 a number that I can multiply and I simply cant remember how to cast it as an int properly.
I did try =INT(E2)+(E2-INT(E2))/0.6 but it looks ok, until you give it more than 2 decimal places, then it turns from 0.35 to 0.347
Any Ideas guys?
In one cell I have number of hours worked in time format e.g. 8:00 hours.
In the next cell I have the hourly pay rate in currencly format e.g. $22.50
In the next cell I want to be able to multiply 8.00 hours by $22.50 to get
the daily amount of pay but when I multiply the 2 cells I get some figure
which is way off. Does anyone know how I can do this ?
I am having trouble with an if statement that calculates pay rates. The
rules are the first 20 hours are straight time, the next 10 (Between 20 and
30 hours) are at 1.5 times the hourly rate, then anything over 30 hours is 2
times the hourly rate. I am obvoiusly multiplying all of my hours here by
it's hourly rate times 2 - I just can't seem to fit it all in without adding
Start time Stop time Hrly rate Hours worked Gross pay Correct Answer
7:00 22:57 10.75 39:57 $859.14 $590.39
Sorry for this lame post.....
I've a cell showing the amount of hours spent on a project (68:45:00).
My hourly rate is $ 105
How do I convert the hours into a number which I can then multiply with 105
to get the correct cost?
I'm using Excel to keep track of my hours at work, which is great. What I'd love to do is have the total hours multiplied by my hourly wage in another column, so I can know what to expect on my paycheck. I thought it was as simple as clicking another cell and choosing the Total Hours cell and multiplying it by the hourly wage but that doesn't seem to work.
My Total Hours cell (E4) is formatted using [h]:mm:ss. If I try and simply multiply, like =E4*wage, I get an odd number, that I think is formatted as time. If I try to change it to currency, I get a really small number like $10.78, and it's the same result if I switch the formatting to General or just Number.
What am I doing wrong? What formula am I supposed to use, or am I using the wrong formatting?
Any help or insight would be appreciated. Thanks everyone!
Happy New Year everyone!
Here's my scenario:
I would like to enter a vacation code in E5 (V12) and have it automatically enter "VACATION DAY (12 HRS * $15/HR) in K5 and calculate the amount in L5. Of course, there are variables involved he
V indicates that it is a vacation day.
12 indicates the number of vacation hours to be taken.
The $15/hr comes from the value in I5.
I don't know if this should be handled as a VLOOKUP along with other methods or if this is something that needs to be handled in VB?
Thank you so much for any help you may be able to provide!
******** ******************** src="*********>
Microsoft Excel - PAYROLL TEMPLATE (NEW TEST).XLS
___Running: 11.0 : OS = Windows XP
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
BI-WEEKLY PAY PERIOD FOR 11/28/07 - 12/11/07
DAY OF WEEK
LUNCH TAKEN (L)
TOTAL REG HOURS
VACATION DAY (12 HRS * $15/HR)
TOTAL OT HOURS
VACATION DAY (8 HRS * $15/HR)
WEEK 1 TOTAL
WEEK 1 TOTALS
WEEK 1 HOURLY WAGES
WEEK 1 OTHER EARNINGS
TOTAL REG HOURS
TOTAL OT HOURS
TOTAL PAYCHECK (WEEK 1 + WEEK2)
WEEK 2 TOTAL
WEEK 2 TOTALS
WEEK 2 HOURLY WAGES
WEEK 2 OTHER EARNINGS
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
I am used to the basic functions of excel and now find myself extremely frustrated. I bill hours worked (not from a start to finish time) on specific projects. I might have to add a 2nd or 3rd phase of additional hours and then need to total those hours to work out the billing.
Phase 1 2hrs 10mins
Phase 2 1 hr 55 mins
Phase 3 45 mins
How do I enter this so it reads the hours and minutes to calculate total time which I can multiply by the hourly rate we charge?
Hiya. I haven't used Excel in awhile, and have forgotten what I assume has to be an easy formula for figuring out gross income in my table. I do have it calculating the hours worked minus lunch, and totalling that for one number (e.g. 31:50) and now need to multiply that by rate of pay ($15/hr). I'd even like to make it more complicated and have the total hours per week calcuated, then have a column for whatever overtime (over 40:00) and multiply the up-to-40 hours times $15, and anything over that times $22.50, then add all that together........
If anyone can give me a hand, that'd be great. Thanks in advance!
(I'll edit this in a minute after I review the "how to copy/paste your excel grid into posts without it looking ridiculous" for a sample... thanks!)
I'm thinking there isn't a simple way to do this, but I'd like to know for sure for my future reference.
The scenario is this: the sheet is a budget, and the hours worked consist of a range, say, 5 - 7. Is there a way to take this range, keep it in one cell, multiply it by some sort of hourly rate, and produce a total range? Ideally, I'd want this:
Hours Rate Total
5-7 $100 $500-$700
And then I'd like to be able to continue to manipulate the numbers in the total column in further formulas.
I know this isn't really reasonable, and there are better ways to do it, but I'd really like to know if I can confine these ranges to single cells and still work with them.
I am trying to set myself up a timesheet using Office 2007 (OS - Vista Home Premium 32 bit)
I enter my start time and finish time and ask for the time difference - I then have a hidden column which converts the time difference to a general number so I can use it to multiply with my hourly rate. My problem is that the hidden column does not return the converted minutes, just the hours so therefore when I multiply it with my hourly rate is not correct as it misses the minutes.
This is how it looks in row 3
In A3 I enter the date e.g. 10/03/08
In B3 I enter my start time e.g. 09:30
In C3 I enter my finish time e.g. 17:00
In D3 I have =IF(A3="","",C3-B3) which returns 08:30
In E3 I have =IF(D3="","",HOUR(D3)) which returns 8 (this is a hidden column)
This is where the problem lies as I need it to convert 08:30 to 8.5 so i can multiply it with my hourly rate.
In F3 I have =IF(E3="","",IF(E3>=7,$F$1,IF(E3=4,$F$1/2,$F$1/7.5*E3))) which returns what I should charge but if I work anything with a 1/2 hour in it the results do not calculate it.
I'm sure this is something very simple and would appreciate any help with which function I should use in E3 to return the 8.5 needed.
Every week our payroll department has to recalculate hourly rates for a number of union employees.
This becomes time consuming because its a lot of trial and error.
Employee A gets $2775 every paycheck regardless of the number of hours worked. Kind of like salary.
Overtime hourly rate is always 1.5 the regular rate.
So what I need help on is a formula that will calculate what C2 in Example 1 should be. Through trial an error I figure out that C2 should be $30.96 and C11 should be $28.84. Is that possible?
Or is there an easier way to do this?
How do you Calculate the weekly pay for each employee. Remember there are salary and hourly employees. Hourly employees will be paid 1.5 times their hourly rate for any hours worked above 40.
1. Wilma's payrate is $150,000 yearly at 40 hrs.
2 John's payrate is $7.50 hourly at 44 hrs.
Can someone help with a small problem that I'm having. I'm trying to format
a group of cells so I can calculate hours of work , then multiply that by my
hourly wage. I'd like it to read so that I can add a list of hours and then
multiply it by the hour rate of pay. (I.E. 8.30 hr + 8.30 hr + 8.30 hr =
25.30 X $10.00 = $253.00 )