计算工龄年月的函数(excel计算工龄年月日)

导读 ="是"&DATEDIF(B1,NOW(),"y")&"年"&DATEDIF(B1,NOW(),"ym")&"月"&DATEDIF(B1,NOW(),"md")&"天"&HOUR(NOW()-B1)&"小时"&MINUTE(NOW()-B1)&"分钟"&SECOND(NOW()-B1)&"秒"。

="是"&DATEDIF(B1,NOW(),"y")&"年"&DATEDIF(B1,NOW(),"ym")&"月"&DATEDIF(B1,NOW(),"md")&"天"&HOUR(NOW()-B1)&"小时"&MINUTE(NOW()-B1)&"分钟"&SECOND(NOW()-B1)&"秒"。

免责声明:本文由用户上传,如有侵权请联系删除!