¦U¦ì¤j¤j¦n
§Ú¦³¤@ÓEXCELÀɮסAÃþ¦üû¤u¸ê®Æ
©m¦W ¤u§@²Õ§O ¦~¸ê
A B C
¤p©ú ¹q¾÷A²Õ 1¦~0¤ë20¤é
¤pµØ ¹q¾÷B²Õ 2¦~10¤ë0¤é
¤p¤ý ªoº£A²Õ 0¦~0¤ë25¤é
¤j·§¹³³o¼Ë
¦~¸êªº³¡¤À¡A¤w¸g°Ý¨ìµª®×¤F¡A¦]¬°§ÚnÂà´«¦¨OO¦~OO¤ëOO¤é
D¥h³]¤½¦¡ =TEXT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C1,"¤é",),"¦~",":"),"¤ë",":"),"[hh]¦~mm¤ëss¤é")
¤u§@²Õ§O¡A§Ú¥u»Ýn¤jÃþ¡A¹q¾÷¤£ºÞ¦bA©ÎB¡A´NÅã¥Ü¹q¾÷¡Aªoº£´NÅã¥Üªoº£
E¥h³]¤½¦¡ =IF(MID(B1,1,2)="¹q¾÷","¹q¾÷",IF(MID(B1,1,2)="ªoº£","ªoº£","")) ´N¬O¨úB1«e¨âÓ¦r¡A¬O¹q¾÷´NÅã¥Ü¹q¾÷
¥u¬O¸ê®Æ¦³¤W¦Êµ§¡A§Ú¥Ø«e¥²¶·¥ý³]D¸òE ¡A¦A§â¤½¦¡¶K¤W¦Êµ§
µM«á±o¨ì¥¿½T®æ¦¡ªº¼ÆÈ«á¡A¦A½Æ»s¡A¶K¤WÈ¡A§âB¨ú¥N¡A§âC¨ú¥N
±o¨ì¥H¤Uªº¼Ë¤l
A B C
¤p©ú ¹q¾÷ 01¦~00¤ë20¤é
¤pµØ ¹q¾÷ 02¦~10¤ë00¤é
¤p¤ý ªoº£ 00¦~00¤ë25¤é
¦³¨S¦³¿ìªk³]¤@Ó«ö¶s
¥i¥H¦Û°Ê°»´ú§Ú¶K¶i¨Óªº¸ê®Æ¦³´Xµ§
µM«á¥i¥H¦Û°Ê§âB¸òC¡A¨Ì·Ó§Ú³]ªº¤½¦¡¥hÂàÅÜ
¨Ã¨ú¥N쥻ªºÈ
ÁÂÁÂ |