楼主çéæ±ä¸æ¯å¾æç¡®ï¼ææ以ä¸å ç§ç解ï¼1. å¨A1ä¸è¾å
¥002230åï¼A1èªå¨æ¾ç¤ºä¸º00:22:30解å³æ¹æ¡ï¼éä¸A1, ååï¼ä¸è®¾ç½®ä»»ä½åæ°å°±ç¹å®æï¼ç¶åä¿®æ¹A1åå
æ ¼æ ¼å¼ä¸ºèªå®ä¹æ ¼å¼ 00!:00!:00è¿æ ·A1å®é
å¼å为2230ï¼ä½å
¶æ¾ç¤ºä¸º00:22:30 2. å¨A1ä¸è¾å
¥002230åï¼B1ä¸æ¾ç¤ºä¸º00:22:30解å³æ¹æ¡ï¼B1ä¸è¾å
¥å
¬å¼: =TEXT(A1*1,"00!:00!:00") æ¤æ¶B1ä¸çå®é
å¼ä¸ºå符串åç 00:22:30 æè
ï¼ä¿®æ¹B1为æ¶é´æ ¼å¼ï¼å¹¶å¨B1è¾å
¥å
¬å¼ =TEXT(A1*1,"00!:00!:00")*1 æ¤æ¶B1ä¸å®é
å¼å°±æ¯æ¶é´å¼00:22:30 3. å¨A1ä¸è¾å
¥002230åï¼A1ä¸èªå¨å为æ¶é´å¼00:22:30解å³æ¹æ¡ï¼è¿ä¸ªéè¦ç¨å®æ¥å®ç°ã代ç éè¦æ ¹æ®ä½ çå®é
éæ±æè½ç»åºã
温馨提示:答案为网友推荐,仅供参考