é¦å
å¨Exceléé¢æ¶é´æ¯ä»¥å°æ°çå½¢å¼åå¨çãä¾å¦1å°æ¶ï¼å¨Exceléé¢çäº1/24ï¼1åéå¨Exceléé¢çäº1/1440ï¼è§£éä¸å¤©ä¸º24å°æ¶*60åéãä¸ç§éå¨Exceléé¢çäº1/(24*60*60)ã
æ±åæ¶ç§ä¹åæ两ç§ææï¼
ãã1.ä¸ç§æææ¯å°æ¶é´ä¸çæ¶ãåãç§ç¸å ã éè¦ç¨MODåä½å½æ°å°æ¶ãåãç§åå«ä¹ä»¥ä¸åçç³»æ°å
ä½æ°å¾å°ç¸åºçæ¶é´é¨åï¼ç¶ååç¸å ã
ãã2.ä¸ç§æææ¯æ±ä¸¤ä¸ªæ¶é´ç¸å ãå¦æå为æ¶é´æ ¼å¼ç两个æ°æ®ï¼å¯ä»¥ç´æ¥ç¸å å³å¯ãå¦æéæ åæ¶é´æ ¼å¼ï¼éè¦ç¨TIMEå½æ°æ¥æ ¼å¼åæ¶é´æ°æ®ç¶åå¨ç¸å ã
TIMEå½æ°ï¼(hour, minute, second)
TIME å½æ°è¯æ³å
·æ以ä¸åæ°ï¼
Hour å¿
éã0ï¼é¶ï¼å° 32767 ä¹é´çæ°å¼ï¼ä»£è¡¨å°æ¶ãä»»ä½å¤§äº 23 çæ°å¼å°é¤ä»¥ 24ï¼å
¶ä½æ°å°è§ä¸ºå°æ¶ãä¾å¦ï¼TIME(27,0,0) = TIME(3,0,0) = .125 æ 3:00 AMã
Minute å¿
éã0 å° 32767 ä¹é´çæ°å¼ï¼ä»£è¡¨åéãä»»ä½å¤§äº 59 çæ°å¼å°è¢«è½¬æ¢ä¸ºå°æ¶ååéãä¾å¦ï¼TIME(0,750,0) = TIME(12,30,0) = .520833 æ 12:30 PMã
Second å¿
éã0 å° 32767 ä¹é´çæ°å¼ï¼ä»£è¡¨ç§ãä»»ä½å¤§äº 59 çæ°å¼å°è¢«è½¬æ¢ä¸ºå°æ¶ãåéåç§ãä¾å¦ï¼TIME(0,0,2000) = TIME(0,33,22) = .023148 æ 12:33:20 AMã
注æï¼å¨æ¶é´ç¸å çè¿ç¨ä¸ï¼è¶
è¿24å°æ¶çæ¶é´ä¼å°24å°æ¶å为æ´æ°1åæ¶ä¸æ¾ç¤ºãæ³è¦æ¾ç¤ºå¤§äº24å°æ¶çæ¶é´ï¼è¯·å¨åå
æ ¼æ ¼å¼éé¢è®¾ç½®èªå®ä¹ä¸ºï¼[h]:mm:ss æ ¼å¼ã