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

[¤w¸Ñ¨M]³]©w¤Æ±ø¥ó§ó§ïÃC¦â»PÅܧó¤é´Á³]©w°ÝÃD

[¤w¸Ñ¨M]³]©w¤Æ±ø¥ó§ó§ïÃC¦â»PÅܧó¤é´Á³]©w°ÝÃD

¥»©«³Ì«á¥Ñ jiuhtsair ©ó 2011-11-11 01:10 ½s¿è

¦U¦ì¤j¤j¦n¡G
         §Ú¤U¸ü¤F¤@­Ó´Á¥æ©Òªº¿ï¾ÜÅv¸ê®Æ¡A¥i¬O¹J¨ì¨â­Ó°ÝÃD¡A·Q½Ð¦U¦ì¤j¤j¸Ñ´b¡CÁÂÁ¡I
         1.¦bK©ML¨âÄæ¡A§Ú¥Î®æ¦¡--->®æ¦¡¤Æ³]©w±ø¥ó...¥i¬OµLªkÅܧ󷡦s®æ¤ºªºÃC¦â(¨Ò¦p¤j©ó¹s¬°¬õ¦â¡A¤p©ó¹s¬°ºñ¦â..)
     2. §Ú§âB11Àx¦s®æªº¤º®e¥Î=mid(B11,23,11)ªº¤è¦¡¨ú¥X¤é´Á¡A¥i¬OµLªk§Q¥ÎÀx¦s®æ®æ¦¡--¼Æ­È-->¤é´Á....ªº¤è¦¡¨ÓÅܧó¤é´Á®æ¦¡..½Ð°Ý­n¦p¦ó³B²z?

     ·PÁ¡I

test.zip (27.43 KB)

50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¥»©«³Ì«á¥Ñ binargoo ©ó 2011-10-11 02:32 ½s¿è

¦^´_ 1# jiuhtsair


1.±z­nªº¬O³o¼Ë¡H

2.¤é´Á®æ¦¡ÁÙ¤£¦æ¡A¦³½Ð¨ä¥L¤j¤j½ç±Ð¡I








test888.rar (20.99 KB)
¥u¬°¾Ç²ß©Ò¥Hµo°Ý

TOP

2
=mid(B11,23,11) ¨ú¥Xªº¬O¤å¦r¨Ã«D¤é´Á

=DATE(MID(B11,23,4),MID(B11,28,2),MID(B11,31,2))

TOP

·PÁÂbinargoo¤j¤j©MANGELA¤j¤j¡I¤G¦ì¸Ñ¨M¤F¦h¤é§xÂZ¡I·P®¦¡I
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD