Multiply Total Hours By Hourly Pay 


Multiply Total Hours By Hourly Pay  Excel 
View Answers 
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
=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
Similar Excel Video Tutorials
Date & Time Number  Total Days & Hours Formula
 Use the INT function to calculate total days worked and the TEXT function to calculate total hours worked. See the custom number format for total hour ...
Convert Hours to Days & Hours using MOD & INT functions
 See how to convert hours to days & hours using MOD & INT functions. ...
Calculate Gross Pay For Week From Time Values In Range & Hourly Wage
 Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn how to calculate gross pay for week from time values in range and the hour ...
Learn how to calculate gross pay for week from time values in range and the hour ...
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 ...
1.Calculating Gross pay using the ROUND function
2.Overtime for over 40 hours worked in a week
3.Overtime for over 40 hour ...
Helpful Excel Macros
Hide Formulas in a Worksheet and Prevent Deletion
 This macro will hide all formulas within a workbook and not allow them to be deleted. The page will not be protected li
 This macro will hide all formulas within a workbook and not allow them to be deleted. The page will not be protected li
Determine if a Cell Contains a Function in Excel  Great for Conditional Formatting and Validation  UDF
 Determine if a cell in Excel contains a formula or function with this UDF (user defined function). This function return
 Determine if a cell in Excel contains a formula or function with this UDF (user defined function). This function return
Format Cells as a Percentage in Excel Number Formatting
 This free Excel macro formats a selection of cells as a Percentage in Excel. This simply changes a cell's number format
 This free Excel macro formats a selection of cells as a Percentage in Excel. This simply changes a cell's number format
Change Formulas to Absolute or Relative References
 This macro will change the formulas in cells to absolute or relative. It allows you to change the rows or the columns o
 This macro will change the formulas in cells to absolute or relative. It allows you to change the rows or the columns o
Name Worksheets Based on Cell Contents
 This macro allows you to have your worksheets named by whatever is in a particular cell within a worksheet. This means
 This macro allows you to have your worksheets named by whatever is in a particular cell within a worksheet. This means
Similar Topics
Hi! I'm hoping someone can help me, please! I need to multiply the number of hours by a daily rate if the hours are 4 hours or more. and I need to multiply the number of hours by an hourly rate if the number of hours is 3 or less. I need it to round up to the next hour if the number of minutes is greater than 15. My formula is working great except for when the hours are 4 and the minutes are from 0 to 14 it wants to multiply by the daily rate. I'm thinking I need the hour qualifier in the beginning of the formula so that it will test if it is four hours and stop and not mess with the minutes? I tried to fix it and I ending up getting the daily rate when I had 3:16 minutes for example because it was rounding to 4. 3:16 minutes would only be the hourly rate because it wasn't actually greater than 4 hours. Any thoughts? Following is my formula:$A$83 is the daily rate and $A$84 is the hourly rate,
=IF(IF(MINUTE(AA3)<=14,HOUR(AA3),HOUR(AA3)+1)>4,$A$83,IF(MINUTE(AA3)<=14,HOUR(AA3),HOUR(AA3)+1)*$A$84)
I would greatly appreciate any help that could be offered.
Thanks again.
Angela
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 recalculate when a new hourly rate is put into the hours sheet.
Example
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
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 recalculate when a new hourly rate is put into the hours sheet.
Example
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?
Thanks.
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?
Thanks.
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
hours.
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
reached)
problem 2 how do I multiply the totla individual hours by the individual
hourly rates to obtain a total value?
hours.
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
reached)
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).
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).
Hi All
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 = C7B7+12 is 8 hours.
BUT.....
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.
Bill
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 = C7B7+12 is 8 hours.
BUT.....
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.
Bill
So, i have a table which is coordinating 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.
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.
=SUM(I4*I2)+(J4*J2)+(K4*K2)+(L4*L2)+(M4*M2)+(N4*N2)
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 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.
=SUM(I4*I2)+(J4*J2)+(K4*K2)+(L4*L2)+(M4*M2)+(N4*N2)
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?
Hello All,
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
(per week)
Annual Salary Hourly Rate Weekly Rate $0.000
Thanks.
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
(per week)
Annual Salary Hourly Rate Weekly Rate $0.000
Thanks.
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.
Thanks,
Thanks,
Hours Worked Normal Hours After Hours Pay Start 8:30:00 PM 8:30 3:30 5:00 3.50 5.00 23:54 Finish 5:00:00 AM
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
=HOUR(D2)+((MINUTE(D2)*0.01)*(1.66))
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)+(E2INT(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?
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!
Please help.
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 ?
Thank You
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 ?
Thank You
Hello,
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
additional coulmns.
Start time Stop time Hrly rate Hours worked Gross pay Correct Answer
7:00 22:57 10.75 39:57 $859.14 $590.39
Any Suggestions?
Thank you,
Denise
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
additional coulmns.
Start time Stop time Hrly rate Hours worked Gross pay Correct Answer
7:00 22:57 10.75 39:57 $859.14 $590.39
Any Suggestions?
Thank you,
Denise
Hi guys
I've attached a sheet which I use for invoicing. Some employees are paid hourly and some are paid a day rate. When I input data into the hourly rate employees the sub total calculation is correct. When I input data into the flat rate employees the sub total calculation isn't adjusted.
D15 holds the amount of hours worked for an hourly employee. V15 holds the amount calculated. D97 holds the amount of hours worked for an hourly rate employee. V109 is supposed to make the calculation but doesn't.
Thanks
Beanie
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?
Regards
Mr. Smith
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?
Regards
Mr. Smith
Hi everyone,
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!
 K
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!
 K
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 F4 L4 H5 J5 F7 L7 D8 F8 H8 I8 J8 L8 D9 D10 F10 L10 J11 L11 M11 F13 L13 F14 H14 I14 J14 L14 F16 L16 D17 F17 H17 I17 J17 L17 D18 D19 F19 L19 N19 J20 L20 M20 =
A B C D E F G H I J K L M N O 1 BIWEEKLY PAY PERIOD FOR 11/28/07  12/11/07 2 EMPLOYEE: SCHMO, JOE STATUS: FULL TIME POSITION: PARAMEDIC 3 DATE DAY OF WEEK HOURS WORKED LUNCH TAKEN (L) HOURLY WAGES OTHER EARNINGS TOTAL OTHERS COMMENTS 4 WEEK 1 11/28/07 WED
TOTAL REG HOURS HRS RATE/HR REG PAY 5 11/29/07 THU V12 0:00 $ 15.00 $  VACATION DAY (12 HRS * $15/HR) $ 180.00 6 11/30/07 FRI 7 12/01/07 SAT
TOTAL OT HOURS HRS RATE/HR OT PAY 8 12/02/07 SUN
0:00 $ 22.50 $  9 12/03/07 MON
V8 VACATION DAY (8 HRS * $15/HR) $ 120.00 10 12/04/07 TUE
WEEK 1 TOTAL 11 WEEK 1 TOTALS WEEK 1 HOURLY WAGES $  WEEK 1 OTHER EARNINGS $ 300.00 $ 300.00 12 13 WEEK 2 12/05/07 WED
TOTAL REG HOURS HRS RATE/HR REG PAY 14 12/06/07 THU
0:00 $ 15.00 $  15 12/07/07 FRI 16 12/08/07 SAT
TOTAL OT HOURS HRS RATE/HR OT PAY 17 12/09/07 SUN
0:00 $ 22.50 $  TOTAL PAYCHECK (WEEK 1 + WEEK2) 18 12/10/07 MON
19 12/11/07 TUE
WEEK 2 TOTAL $ 300.00 20 WEEK 2 TOTALS WEEK 2 HOURLY WAGES $  WEEK 2 OTHER EARNINGS $  $  MEDICS
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
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 F4 L4 H5 J5 F7 L7 D8 F8 H8 I8 J8 L8 D9 D10 F10 L10 J11 L11 M11 F13 L13 F14 H14 I14 J14 L14 F16 L16 D17 F17 H17 I17 J17 L17 D18 D19 F19 L19 N19 J20 L20 M20 =
A B C D E F G H I J K L M N O 1 BIWEEKLY PAY PERIOD FOR 11/28/07  12/11/07 2 EMPLOYEE: SCHMO, JOE STATUS: FULL TIME POSITION: PARAMEDIC 3 DATE DAY OF WEEK HOURS WORKED LUNCH TAKEN (L) HOURLY WAGES OTHER EARNINGS TOTAL OTHERS COMMENTS 4 WEEK 1 11/28/07 WED
TOTAL REG HOURS HRS RATE/HR REG PAY 5 11/29/07 THU V12 0:00 $ 15.00 $  VACATION DAY (12 HRS * $15/HR) $ 180.00 6 11/30/07 FRI 7 12/01/07 SAT
TOTAL OT HOURS HRS RATE/HR OT PAY 8 12/02/07 SUN
0:00 $ 22.50 $  9 12/03/07 MON
V8 VACATION DAY (8 HRS * $15/HR) $ 120.00 10 12/04/07 TUE
WEEK 1 TOTAL 11 WEEK 1 TOTALS WEEK 1 HOURLY WAGES $  WEEK 1 OTHER EARNINGS $ 300.00 $ 300.00 12 13 WEEK 2 12/05/07 WED
TOTAL REG HOURS HRS RATE/HR REG PAY 14 12/06/07 THU
0:00 $ 15.00 $  15 12/07/07 FRI 16 12/08/07 SAT
TOTAL OT HOURS HRS RATE/HR OT PAY 17 12/09/07 SUN
0:00 $ 22.50 $  TOTAL PAYCHECK (WEEK 1 + WEEK2) 18 12/10/07 MON
19 12/11/07 TUE
WEEK 2 TOTAL $ 300.00 20 WEEK 2 TOTALS WEEK 2 HOURLY WAGES $  WEEK 2 OTHER EARNINGS $  $  MEDICS
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
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.
i.e.
Job A
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?
Desperate
i.e.
Job A
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?
Desperate
Hello,
I am looking for the best type of formula that will allow me to multiply a value from one table to an associted value in a second table and display the result in a third table.
EXAMPLE
I have two source data tables, the first of which breaks down the number of hours members of a team have spent on a particular task: In each row I will have a particular activity (e.g. Activity A, Activity B, Activity C). In each column I will have a resource name (e.g. Resource A, Resource B, Resource C) The values in the table will be the number of hours each resource has spent on a particular task each month.
I want to be able to multiply the number of hours worked per month on a particular task with the hourly cost rate of that particular resource. I want to then display a summed value of these calculations in a selection of summary dashboards for wider distribution.
I'm not sure what the best formula to use to multiply the number of hours in one table, with a particular value in another table. I've attempted a combination of SUMPRODUCT and LOOKUP functions, but not sure this is best way?
I've attached a simplified version of my draft model to assist.
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 upto40 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!)
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
57 $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.
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
57 $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.
Hi,
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="","",C3B3) 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.
Many Thanks
Zobble!
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="","",C3B3) 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.
Many Thanks
Zobble!