ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ®É¶¡®æ¦¡Âà´«

[µo°Ý] ®É¶¡®æ¦¡Âà´«

§Ú¦³¤@¤jµ§±q¨t²Î¸ê®Æ¶×¥Xªº®É¶¡®æ¦¡¦p¤U

2011/11/12 ¤W¤È 03:11:05
2011/11/12 ¤W¤È 02:50:20
2011/11/12 ¤W¤È 02:28:53
2011/11/12 ¤W¤È 02:06:33
2011/11/12 ¤W¤È 01:45:24
2011/11/12 ¤W¤È 01:25:05
2011/11/11 ¤U¤È 11:58:39

³o¨Ç®É¶¡¸ê®Æ¶×¥X«áªº¼Æ­ÈÃþ§O¬°³q¥Î®æ¦¡
¥»¨Ó±N³o¨Ç®É¶¡ªº¼Æ­ÈÃþ§O§ï¬°[$-409]yyyy/m/d ¤W¤È/¤U¤È h:mm:ss;@
¦ý¬Oµo²{³o¨Ç¸ê®Æ¤¤¶¡ªº¡u¤¤¤È¡v¡B¡u¤U¤È¡vÅý§Úªº®æ¦¡¨S¦³¿ìªk§@¥Î
§Ú­n¦p¦ó±N³o¨Ç®É¶¡¸ê®Æ§ï¬°¥¿±`ªº®É¶¡¸ê®Æ
Âà´««á¥i¥HÅý§Úª½±µ°w¹ï³o¨Ç®É¶¡¸ê®Æ°µ¥[´î¹Bºâ

¥»©«³Ì«á¥Ñ handmuch ©ó 2011-11-15 15:35 ½s¿è

¦^´_ 1# callinner


   

¦A­×§ïÀx¦s®æ®æ¦¡

TOP

=TEXT((LEFT(A2,10)&" "&RIGHT(A2,8))&MID(A2,11,3),"yyyy/mm/dd hh:mm:ss")
=TEXT(MID(A1,1,10)+MID(A1,15,8)+ISNUMBER(FIND("¤U",A1))/2,"yyyy/mm/dd hh:mm:ss")
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 3# gong

¦^´_ 2# handmuch

OK¡A¸Ñ¨M¤F
¤£¹L¬°¤°»ò
=TEXT(MID(Q4,1,10)+MID(Q4,15,8)+ISNUMBER(FIND("¤U",Q4))/2,"yyyy/mm/dd hh:mm:ss")
³o¸Ì¤£¬OÅã¥Ütrue or false¡A¬°¤°»ò­n°£¥H2¡H

TOP

ISNUMBER(FIND("¤U",Q4))/2
¤W¤È®Éisnumber(..)¬°false=0,©Ò¥H¤£¥[®É¶¡,

¤U¤È®Éisnumber(..)¬°true=1
¤U¤È®É¶¡¦pªG13:00·|Åã¥Ü¤U¤È01:00
¤U¤È®É¶¡®t12:00,¤@¤Ñ¬°1¬G/2§Y¬°12¤p®É
01:00+12¤p®É§Y¬°¤U¤È®É¶¡
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¥t¸Ñ
=REPLACE(A1,12,2," ")+ISNUMBER(FIND("¤U",A1))/2

TOP

        ÀR«ä¦Û¦b : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD