時間加總 超過24小時的表示 (15046)

H2:C4=TEXT(SUMPRODUCT((LOOKUP(ROW(2:16),ROW(2:16)/($C$2:$C$16>0),$C$2:$C$16)=H$1)*(MONTH($D$2:$D$16)-LEFTB($G2,2)=0)*$E$2:$E$16),"[H]:MM")