Formating Cells to Calculate Hours of Work

[Doug Jones]

Can someone help with a small problem that I'm having. I'm trying to format
a group of cells so I can calculate hours of work , then multiply that by my
hourly wage. I'd like it to read so that I can add a list of hours and then
multiply it by the hour rate of pay. (I.E. 8.30 hr + 8.30 hr + 8.30 hr =
25.30 X $10.00 = $253.00 )




(@ @)
----------o00o-(_)-o00o----------

 

[Peo Sjoblom]

Use real time format like 8:30, just sum the total, assume

=SUM(A1:A3)*24*10

with 8:30 in all cells

format as General, number or currency will return 255 not 253
if you mean that 8.30 is 8 hours and 30 minutes, If you mean 8.3 hours than
the
amount would be 249

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Doug Jones]

Hi,
That doesn't seem to work as I would like. I'm trying to formulate a
cell so that if I enter a time of 1 hours and 32 minutes, I would like to
be able to multiply that amount of time by a hourly rate of $36.00. It
should come out to $55.20, but when I use =SUM(A1)*36 as a formula, I get
$47.52.

Any help you could give me with this matter would be great

Thanks.......Doug

 

[Peo Sjoblom]

USE time that excel can understand so if you want 1 hour and 32 minutes it
should be entered as
1:32, then if you put that in A1 and then use A1*24*36 AND format result as
general or currency it WILL return 55.20

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Doug Jones]

Thanks Peo,

That worked great, I changed the cell like you said and everything
worked out the way it should.

Thanks again

Doug