C2{=SUBSTITUTE(TEXT(SUM(ISNUMBER(FIND("@"&ROW($1:$99)&"年","@"&A2:B2))*ROW($1:$99))+SUM(ISNUMBER(FIND("年"&ROW($1:$12)&"个","年"&A2:B2&"个"))*ROW($1:$12))/12,"#年#个月/12年;;"),"/12年",)
另解{=SUBSTITUTE(TEXT(SUM(--SUBSTITUTE(SUBSTITUTE(IF(ISERR(FIND("年",A2:B2)),"0年",)&A2:B2,"年"," "),"个月","/12")),"#年#个月/12年;;"),"/12年",)
另解{=SUBSTITUTE(TEXT(SUM(MIDB(10&A2:B2&1%,FINDB({"年";"个"},A2:B2&"0年个"),2)/{1;12}),"#年#个月/12年;;"),"/12年",)
留言
張貼留言