中文年月 加總 (15355)

D2{=SUM(LEFTB(B2:B9,2)*1)+INT(SUM(RIGHTB(LEFT(B2:B9,FIND("月",B2:B9)-1),2)*1)/12)&"年"&MOD(SUM(RIGHTB(LEFT(B2:B9,FIND("月",B2:B9)-1),2)*1),12)&"月"



留言