Hour multiply by a value
 

It's like this:

in one cell I have the sum of some cells with a number of hours made by
a worker in that week, something like:

42:36:00

And on another cell i've got the amount of €(euros) I pay by hour to a
worker.
by example, 5.

So what I want to do is: arrange a way to know how much i'm going to
pay him at the end of the week.

I've tried working with the HOUR and MINUTE commands. but with the HOUR
i will only go up to 23, so it doesn't work.

Help...


--
FixxxeR
------------------------------------------------------------------------
FixxxeR's Profile: http://www.excelforum.com/member.php...o&userid=29798
View this thread: http://www.excelforum.com/showthread...hreadid=495071

Hour multiply by a value
 

42:36:00 is really 1.775 days. So use

=A1*24*5
--
Gary's Student


"FixxxeR" wrote:


It's like this:

in one cell I have the sum of some cells with a number of hours made by
a worker in that week, something like:

42:36:00

And on another cell i've got the amount of ‚¬(euros) I pay by hour to a
worker.
by example, 5.

So what I want to do is: arrange a way to know how much i'm going to
pay him at the end of the week.

I've tried working with the HOUR and MINUTE commands. but with the HOUR
i will only go up to 23, so it doesn't work.

Help...


--
FixxxeR
------------------------------------------------------------------------
FixxxeR's Profile: http://www.excelforum.com/member.php...o&userid=29798
View this thread: http://www.excelforum.com/showthread...hreadid=495071