excluded time computation

[Rhon Alvarez]

Hi Team,

any help with regards to time computation; my formula only reads those in hours and even if i do add the formula "minute", it doesn't count those entries of 0:30 mins.
for example:
CORE = 26.00 when it should have been 27.00
TMT = 5.00 when it should have been 5.30

thanks in advance.

 

[bosco_yip]

Try,

In AB2, copied down :

=(SUMIF(R:R,AA2,G:G)+SUMIF(R:R,AA2,J:J)+SUMIF(R:R,AA2,M:M))*24

Regards
Bosco

 

[vletm]

Rhon Alvarez
Would this help You?

 

[John Jairo V]

Hi!

Just for fun... another option could be:
[AB2] : =SUMPRODUCT((R$3:R$23=AA2)*(G$2:M$2="Total"),G$3:M$23)*24
or
[AB2] : =SUM(SUMIF(R:R,AA2,OFFSET(G:G,,{0,3,6})))*24

Blessings!