数字分別求和 (11478)

G2{=SUM(IFERROR(LEFT(C4:L4,FIND("（",C4:L4)-1)*1,))&"（"&SUM(IFERROR(MID(LEFT(C4:L4,LEN(C4:L4)-1),FIND("（",C4:L4)+1,9)*1,))&"）"

另解{=SUBSTITUTE(SUBSTITUTE(IMSUM(SUBSTITUTE(SUBSTITUTE(0&C4:K4,"（","+"),"）","i")),"+","（"),"i","）")

以時間算  分 > 59 有誤{=TEXT(SUM(IFERROR(SUBSTITUTE(LEFT(C4:L4,LEN(C4:L4)-1),"（",":")*1,)),"[H]!（M")&"）"