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

[µo°Ý] ¤å¦rÂà®É¶¡®æ¦¡

[µo°Ý] ¤å¦rÂà®É¶¡®æ¦¡

½Ð°Ý¥ý¶i¦p¦ó±N¤U­±ªº¤å¦r®æ¦¡Âର®É¶¡®æ¦¡~ ÁÂÁÂ
2010/09/10 ¤U¤È 06:13:16  ==> 2010/9/10 18:13:16
2010/09/04 ¤W¤È 02:53:08 ==> 2010/9/4 2:53:08

B1=DATEVALUE(LEFT(A1,10))+IF(ISERROR(FIND("¤U",A1)),TIMEVALUE(RIGHT(A1,8)),TIMEVALUE(RIGHT(A1,8))+0.5)
®æ¦¡§ï¬°¤é´Á¥[®É¶¡

TOP

=DATEVALUE(LEFT(A1,10))+TIMEVALUE(RIGHT(A1,8))+IF(ISNUMBER(FIND("¤U¤È",A1)),0.5,0)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

­Y¤w¸g¬O¤é´Á®æ¦¡¡A¦p¹Ï¡A¨º´N¤£³Â·Ð¡Aª½±µ§ï®æ¦¡§Y¥i¡C 2010-09-14_165753.jpg

TOP

·PÁ ANGELA ¤Î Hsieh ª©¤j  ªº¸Ñµª, ¯¬¶¶¤ß~~

To Oobird ª©¤j,
     «x! ª©¤j«ç»ò°µ¨ìªº©O? ¤@¶}©l§Ú¤]·Q»¡ª½±µ¦Û­q®æ¦¡¥h­×§ï
     ¥i±¤¥\¤O¤Ó®t.......§ï¤£¥X¨Ó, ¥i§_½Ð±ÐOobird ª©¤j ¸Ô­z~ ·P®¦

TOP

¹Ï¤¤ªº®æ¦¡¬O¡G[$-404]yyyy/mm/dd AM/PM hh:mm:ss

TOP

¦^´_ 5# cw3076


    oobirdª©¥Dªº¹ÏÀ³¬O§A©Ò¿é¤Jªº¬O¤é´Á®É¶¡¡A¦Ó®æ¦¡³]©wÅý§A¬Ý¨ì¤W/¤U¤È
¹ê»Ú¤W¤w¸g¸Õ¤é´Á®É¶¡ªº­È
­Y¥H§A¿é¤J¬°2010/9/10 ¤W¤È 08:30:00³o¼Ëªº¿é¤JEXCEL¬O¤£·|·í¦¨¤é´Á¡A¥u·|»{¬°³o¬O¦r¦ê
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

Dear ¤j¤j,
¥X²{¤@­Ó°ÝÃD, ²z½×¤W12¤p®É¨î¹L¤¤¤È12:00¬O¤£¬O¥Ñ00:00¶}©l°O®É,¦ý
¹ê»Ú¤W­nµ¥¨ì¤U¤È¤@ÂI¨t²Î¤~·|Åܦ¨ ¤U¤È 01:00, ¹L12ÂI¤´·|¥H12:00ªí¥Ü
©Ò¥H¤W­z ¤j¤j´£¨Ñªº ¤@¹J¨ì¤¤¤È12ÂIªº®É¶¡·|¦h¥[12¤p®É, ¥i§_½Ð¤j¤j«ü±Ð~

2010/09/15 ¤U¤È 12:02:27 -->2010/9/16 0:02  Wrong

TOP

=DATEVALUE(LEFT(A1,10))+TIMEVALUE(RIGHT(A1,8))+IF((TIMEVALUE(RIGHT(A1,8))<0.5*ISNUMBER(FIND("¤U¤È",A1))),0.5,0)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·P®¦,
ÁÂÁª©¤j~

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD