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

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

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

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

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

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

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

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

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

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