他姥爷 发表于 2021-10-21 11:44:00

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


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

藿香正气 发表于 2021-10-22 23:31:55

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

镇东 发表于 2021-10-31 05:23:44

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

万荣浩 发表于 2021-10-31 07:14:25

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

太阳儿子 发表于 2021-11-3 10:40:10

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

天降石天珠 发表于 2021-11-13 05:53:20

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

依洺 发表于 2021-11-15 18:53:06

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

不问朝歌 发表于 2021-11-17 23:51:52

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

几分之几 发表于 2021-11-18 23:49:03

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

绿茶的味道 发表于 2021-11-23 14:02:06

回复可以设置背景色喔
页: [1] 2 3 4
查看完整版本: 如何把46个月换算成*年*个月