导读 ="是"&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)&"秒"。