Posts by munirh

Re: Multiplying Time with Manhours

Woohoo!
Thanks, it works
Munir

Re: Multiplying Time with Manhours

I have tried doing that but no difference

Hi
I'm trying to calculate the total manhour cost for a job done. I'm using this formula but don't seem to get the correct answer. Can anyone please help.

Formula Used:
((B30-INT(B30))*24)*58

B30 = 56:00:00 (56 hours)
58 = Manhour cost

Since the time taken is more than 24 hours it is not returning the correct value, not sure if there is a way to work around.

thanks
Munir

Re: Add &amp; Multiply Man-hours - Different results

Thanks for the formula, it works.(I know it should)
Out of curiosity, C13=sum(c6:c12) and C27=sum(c20:c26)
D20 to D26 each cell is a result of C6*C20, so on and so forth. I thought multiplying c13 with C27 should be the same as adding all the results of multiplying each of the cells.

Hi i'm trying to calculate the manpower required to get the job done for few tasks.
I have calculated the time for each task and totaled, which amounts to 2:44:00. I have calculated the total man-hour to perform the "total issued" by multiplying the respective cells.
However, sum(D20,D26) (as shown in D28) is different from c27*C13 (as shown in D27)
Am i missing something here, why are the 2 results different.