çä½ çè´´å¾ï¼è²ä¼¼ä½ çæ°æ®æ¯ææ¬æ ¼å¼ï¼åå·æ¯
å
¨è§çï¼ï¼èä¸æ¯çæ£çæ¶é´æ°æ®ï¼æ以æ±ååºéå°±å¨æé¾å
äºã
解å³åæ³ä¸ï¼å¨ç©ºç½åå
æ ¼ä¸è¾å
¥æ°åï¼å¤å¶è¯¥åå
æ ¼ï¼åéæ©æ¶é´æ°æ®åºåï¼å³é®èåä¸éæ©âéæ©æ§ç²è´´âï¼åéæ©âä¹âï¼æ¶é´åºååºè¯¥ä¼åæ纯å°æ°ï¼å设计åå
æ ¼æ ¼å¼ä¸ºæ¯æ¶é´ãç¶åæ±åã
解å³æ¹æ³äºï¼åè®¾ä½ çæ¶é´æ°æ®å¨B1:B100ï¼ç¨å
¬å¼ï¼
=TEXT(SUM(--B1:B100),"[h]:mm")
åæ¶æCtrl+Shift+Enterä¸é®è¾å
¥æ°ç»å
¬å¼
å¦æåªæ¾ç¤ºå
¬å¼ï¼èä¸æ¯ç»æï¼å°±è®¾è®¡åå
æ ¼æ ¼å¼ä¸ºå¸¸è§åï¼éæ°åæ¶æCtrl+Shift+Enterä¸é®ã