Hour multiply by a value

[FixxxeR]

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

[Gary''s Student]

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