Time calculation

[aliaslamy2k]

Dear Experts,

I am trying to calculate total time from different sheets with below formula,but i am getting incorrect results. Please give me a correct formula.

=SUMPRODUCT(SUMIF(INDIRECT("'"&BC$1:BC$31&"'!CO2:EH2"),B3,INDIRECT("'"&BC$1:BC$31&"'!CO4:EH4")))


Kind Regards,
Ali

 

[Aladin Akyurek]

Dear Experts,

I am trying to calculate total time from different sheets with below formula,but i am getting incorrect results. Please give me a correct formula.

=SUMPRODUCT(SUMIF(INDIRECT("'"&BC$1:BC$31&"'!CO2:EH2"),B3,INDIRECT("'"&BC$1:BC$31&"'!CO4:EH4")))


Kind Regards,
Ali

Did you custom format the formula cell as:

[h]:mm

 

[aliaslamy2k]

Thanks a million Aladin,

I got the right answer after formatting the cell.


Many thanks ...

Rgds,
AB

 

[Aladin Akyurek]

Thanks a million Aladin,

I got the right answer after formatting the cell.


Many thanks ...

Rgds,
AB

You are welcome. Thanks for providing feedback.