F3{=SUM(LEFT(C3:E3,FIND("/",C3:E3)-1)*1)&"/"&SUM(MID(C3:E3,FIND("/",C3:E3)+1,9)*1)
另解{=SUM(IMREAL(SUBSTITUTE(C3:E3,"/","-")&"i"))&"/"&SUM(MID(C3:E3,FIND("/",C3:E3)+1,9)*1)
另解{=SUBSTITUTE(SUBSTITUTE(IMSUM(SUBSTITUTE(C3:E3&"i","/","-")),"-","/"),"i",)
G3=SUMPRODUCT(("0 "&C3:E3)*1)
留言
張貼留言