Help Please

D

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

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
 
D

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

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

swatsp0p

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
 
S

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
 
O

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

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

Bob Phillips

So what is wrong with the many suggestions offered?

--

HTH

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