Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Please
What is the formula that takes hours that have been added up and multiples them by an hourly wage. I know it can be done. I just don't know how. -- darling ------------------------------------------------------------------------ darling's Profile: http://www.excelforum.com/member.php...o&userid=28855 View this thread: http://www.excelforum.com/showthread...hreadid=486045 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Please
=A8*24*Wage_Rate
where A8 holds the hours, it is important to format result as genreal or numbers or currency or else you'll get a large time format -- Regards, Peo Sjoblom "darling" wrote in message ... What is the formula that takes hours that have been added up and multiples them by an hourly wage. I know it can be done. I just don't know how. -- darling ------------------------------------------------------------------------ darling's Profile: http://www.excelforum.com/member.php...o&userid=28855 View this thread: http://www.excelforum.com/showthread...hreadid=486045 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Please
If the number of hours is in cell A1 and the hourly wage is in Cell A2 the in
cell A3 enter "=A1*A2" darling wrote: What is the formula that takes hours that have been added up and multiples them by an hourly wage. I know it can be done. I just don't know how. -- Message posted via http://www.officekb.com |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Please
=sum (A2:A20)*24*hourly_rate
where a2:A20 holds the hours worked as time amounts -- HTH RP (remove nothere from the email address if mailing direct) "darling" wrote in message ... What is the formula that takes hours that have been added up and multiples them by an hourly wage. I know it can be done. I just don't know how. -- darling ------------------------------------------------------------------------ darling's Profile: http://www.excelforum.com/member.php...o&userid=28855 View this thread: http://www.excelforum.com/showthread...hreadid=486045 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Please
Let's assume you have four times (IN/Out-lunch/IN/Out) in columns C, D, E and F, and your rate is $12.50/hour your formula would look like this: =(((D2-C2)+(F2-E2))*24)*12.5 for a simple IN/OUT it would be: =((D2-C2)*24)*12.5 Does this work for you? Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=486045 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Please
If you need to calculate the hours from IN and OUT times: Let's assume you have four times (IN/Out-lunch/IN/Out) in columns C, D, E and F, and your rate is $12.50/hour your formula would look like this: =(((D2-C2)+(F2-E2))*24)*12.5 for a simple IN/OUT it would be: =((D2-C2)*24)*12.5 of course, format this cell as Peo suggested. Does this work for you? Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=486045 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Please
Hi,
As an example if the wage is £8 ph and the hours are 20 If you put the hours in say A1 then in the cell you want the total Type =A1*8 then enter and it will do it for you. If you have a list of hours then you can the got to the bottom right corner of the cell you have the total in until you see a black cros then drag the mouse down whilst holding the buttont to wherever you want and the formual will move and automatically up date for you! "darling" wrote: What is the formula that takes hours that have been added up and multiples them by an hourly wage. I know it can be done. I just don't know how. -- darling ------------------------------------------------------------------------ darling's Profile: http://www.excelforum.com/member.php...o&userid=28855 View this thread: http://www.excelforum.com/showthread...hreadid=486045 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Please
I managed to get the cells to add up hours and minutes but I need it to then multipy the time by $30. Is that to much to ask? Is it too many formats for one cell? I swear the time I have put into thinking this through is more than I would spent on doing the math for every worksheet but now I just want to figure it out. -- darling ------------------------------------------------------------------------ darling's Profile: http://www.excelforum.com/member.php...o&userid=28855 View this thread: http://www.excelforum.com/showthread...hreadid=486045 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Please
It works. Thank you everyone for making me look so much smarter than I am. -- darling ------------------------------------------------------------------------ darling's Profile: http://www.excelforum.com/member.php...o&userid=28855 View this thread: http://www.excelforum.com/showthread...hreadid=486045 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Please
So what is wrong with the many suggestions offered?
-- HTH RP (remove nothere from the email address if mailing direct) "darling" wrote in message ... I managed to get the cells to add up hours and minutes but I need it to then multipy the time by $30. Is that to much to ask? Is it too many formats for one cell? I swear the time I have put into thinking this through is more than I would spent on doing the math for every worksheet but now I just want to figure it out. -- darling ------------------------------------------------------------------------ darling's Profile: http://www.excelforum.com/member.php...o&userid=28855 View this thread: http://www.excelforum.com/showthread...hreadid=486045 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|