如何把46个月换算成*年*个月

他姥爷

如表想在Q4中把P4的46个月转化成G4的样式

2021年乡镇工作补贴审批花名册.rar (9.71 KB, 下载次数: 15)

2021-10-21 11:44 上传

点击文件名下载附件
2021年乡镇工作补贴审批花名册.rar

藿香正气

=INT(LEFT(P4,FIND("个",P4)-1)/12)&"年"&MOD(LEFT(P4,FIND("个",P4)-1),12)&"个月"

镇东

=ROUNDDOWN(P4/12,0)&"年"&P4-ROUNDDOWN(P4/12,0)*12&"个月"

万荣浩

=SUBSTITUTE(TEXT(SUBSTITUTE(P4,"个月",)/12,"0年0个月/12"),"/12",)

太阳儿子

=INT(SUBSTITUTE(P4,"个月",)/12)&"年"&MOD(SUBSTITUTE(P4,"个月",),12)&"个月"

天降石天珠

=INT(SUBSTITUTE(46,"个月","")/12)&"年"&MOD(SUBSTITUTE(46,"个月",""),12)&"个月"

依洺

=TEXT(DOLLARFR(LEFT(O4,LEN(O4)-2)/12,12)/1%,"0年00个月")

不问朝歌

我只想问问，你楼层里的背景咋弄的？

几分之几

=INT(SUBSTITUTE(P4,"个月",)/12)&"年"&MOD(SUBSTITUTE(P4,"个月",),12)&"个月"

绿茶的味道

回复可以设置背景色喔