A1 è¾å
¥ 2008-8-8 8:8:8
A2 è¾å
¥ =NOW()
A3 è¾å
¥ =A1-A2
A4 è¾å
¥:
=INT(A3)&"天"&TEXT(A3-INT(A3),"hæ¶måsç§")
A4 便æ¯å计æ¶
å¦è¦å计æ¶æ¯ç§è¿è¡, 便è¦æ§è¡å®, VBA代ç :
Sub Olympic()
ActiveSheet.Calculate
Application.OnTime Now + TimeValue("00:00:01"), "Olympic"
End Sub
å¦éåæ¢å计æ¶, è¦å¦å¤åä¸ä¸ªå®
温馨提示:答案为网友推荐,仅供参考