Re: Multiplying Time with Manhours
Woohoo!
Thanks, it works
Munir
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.
Please help
thanks
Munir
Re: Add & 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.
Please help
forum.ozgrid.com/index.php?attachment/35471/