Posts by munirh

• Multiplying Time with Manhours

Re: Multiplying Time with Manhours

Woohoo!
Thanks, it works
Munir

• Multiplying Time with Manhours

Re: Multiplying Time with Manhours

I have tried doing that but no difference

• Multiplying Time with Manhours

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

• Add & Multiply Man-hours - Different results

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.

• Add & Multiply Man-hours - Different results

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.