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