大猴子和小老鼠
发表于 2021-12-28 06:08:20
=ROUNDDOWN(P4/12,0)&"年"&P4-ROUNDDOWN(P4/12,0)*12&"个月"
韩和国
发表于 2021-12-29 23:15:32
=SUBSTITUTE(TEXT(SUBSTITUTE(P4,"个月",)/12,"0年0个月/12"),"/12",)
垻垻
发表于 2021-12-30 09:06:35
=INT(SUBSTITUTE(P4,"个月",)/12)&"年"&MOD(SUBSTITUTE(P4,"个月",),12)&"个月"
活好自已
发表于 2022-1-3 14:43:46
=INT(SUBSTITUTE(46,"个月","")/12)&"年"&MOD(SUBSTITUTE(46,"个月",""),12)&"个月"
行云听风
发表于 2022-1-5 09:32:57
=TEXT(DOLLARFR(LEFT(O4,LEN(O4)-2)/12,12)/1%,"0年00个月")
漂流的冰凌
发表于 2022-1-5 20:28:14
我只想问问，你楼层里的背景咋弄的？
麻春宝
发表于 2022-1-5 23:59:54
=INT(SUBSTITUTE(P4,"个月",)/12)&"年"&MOD(SUBSTITUTE(P4,"个月",),12)&"个月"
专家说我骚
发表于 2022-1-13 03:13:10
回复可以设置背景色喔
烟酉
发表于 2022-1-13 11:03:24
=INT(SUBSTITUTE(P4,"个月",)/12)&"年"&MOD(SUBSTITUTE(P4,"个月",),12)&"个月"
韩喜春
发表于 2022-1-17 02:17:58
=INT(SUBSTITUTE(46,"个月","")/12)&"年"&MOD(SUBSTITUTE(46,"个月",""),12)&"个月"