Help Please

[darling]

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.

[Peo Sjoblom]

=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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[DARREN FONG via OfficeKB.com]

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

[swatsp0p]

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

[Bob Phillips]

=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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Olivia Trimble]

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
>
>

[darling]

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]

It works. Thank you everyone for making me look so much smarter than I am.

[Bob Phillips]

So what is wrong with the many suggestions offered?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"darling" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>