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

µo°Ý:¤é´Á¿é¤Jyyyymmdd¦Û°Ê§PÂ_¬°¤é´Á®æ¦¡

µo°Ý:¤é´Á¿é¤Jyyyymmdd¦Û°Ê§PÂ_¬°¤é´Á®æ¦¡

Ãö©ó¤é´Á»P®É¶¡¿é¤J¡A§xÂZ¤w¤[¡A
³]©wÅã¥Ü®æ¦¡¬°  yyyy/mm/dd »P hh:mm

¦pªG¬O²{¦b®É¶¡³q±` §Q¥Î Ctrl  +; »P Ctrl + Shift +; ¿é¤J
¦ý±`±`»Ý­n¤â°Ê¿é¤J¡A´Á±æ¤é´Á¿é¤J¯Â¼Æ¦r yyyymmdd ®É¶¡ hhmm
§Y 2011/07/10 ©óÄæ¦ì¿é¤J 20110710 ¡A®É¶¡22:45¿é¤J 2245
¹Á¸Õ¥Î¸ê®ÆÅçÃÒ¤S·Q¤£¥X¤èªk
ªþÀɬ°¤âÃäÀÉ®×
·Ð½Ð¦^ÂЮɲ©ö±Ô­z¤èªk¡A¥Ø«eÁÙµL¤U¸üªþ¥[ÀÉÅv­­
[attach]6968[/attach]

­Y¥u¬O­n§ïÅÜÅã¥Ü¼Ë¦¡¡A§â®æ¦¡³]¬°####"/"##"/"##¤Î"##"/"##
ww.gif
2011-7-10 23:19

TOP

·PÁÂchin15ªºÀ°§U¡A¥i¬O§Ú»Ý­n­pºâ³o¨Ç¤é´Á¡B®É¶¡¸ê®Æ
³o¼Ë¿é¤J¸ê®Æ¬°¼Æ­È¡A
§Æ±æ¬O¦p§{¶¡¤@¨ÇÀ³¥Î³nÅ餣»Ý¿é¤J/»P:§Y¦Û°Ê¥[¤J

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-7-12 09:40 ½s¿è

¦^´_ 3# Happkkevin


    ¨º´N­n¦b­pºâ®É§â«D¤é´Á®æ¦¡ªº¼gªkÂà´«¦¨¤é´Á°Ñ¥[­pºâ
¨Ò¦pA1¿é¤J§Î¦¡yyyymmdd
B1=--TEXT(A1,"0000-00-00")
A2¿é¤J§Î¦¡hhmm
B2=--(LEFT(A2,2)&":"&RIGHT(A2,2))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁÂHsieh¶Wª©¡A§xÂZ§Ú¤w¤[ªº³º¦p¦¹§Ö³t¸Ñ¨M
¥u¬O®É¶¡¬°¦óµLªk¥H B2=--TEXT(A2,"00:00")³B²z¡Aµo¥Í¿ù»~
¥ý¦Û¤v¸Ñ¨M¡A¦L¶H·|¸û²`¡A¬ã¨s TEXT ¤¤¡A­Y¦³°ÝÃD¦A´£°Ý
ÁÂÁÂHsieh¶Wª©ªº¸Ñµª

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-7-13 10:11 ½s¿è

¦^´_ 5# Happkkevin


    =--TEXT(A2,"00!:00")
or
    =--TEXT(A2,"00\:00")

TOP

½Ð°Ý¤@¤U00«á­±¥[¤J! or  \ªº§@¥Î¬O¤°»ò


    =--TEXT(A2,"00!:00")
or
    =--TEXT(A2,"00\:00")
Kenny

TOP

¦^´_ 7# ky2599y

¦û¦ì²Å¸¹ªº¥\¯à¡A·N¦b±j¨îÅã¥Ü«á­±ªº¦r¤¸
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  Happkkevin


    =--TEXT(A2,"00!:00")
or
    =--TEXT(A2,"00\:00")
ANGELA µoªí©ó 2011-7-13 10:08

¦^´_  ky2599y

¦û¦ì²Å¸¹ªº¥\¯à¡A·N¦b±j¨îÅã¥Ü«á­±ªº¦r¤¸
Hsieh µoªí©ó 2011-7-15 21:20

¹B¥Î¦¨¥\¡A¥Î¤F¥H«á§Ñ°O¦^´_µ²ªG¡A¤S¦A¬Ý¨ì¶Wª©ªº¦^´_¦h¾Ç¤F¤@¨Ç
·PÁ¨â¦ì¥ý¶iªº¨ó§U
³o¹ï©ó¤p§Ì¥­®É¤u§@¤W§U¯q¤£¤Ö¡A¹ï©ó¿é¤J®æ¦¡¤W
¤×¨ä¬O¤é´Á»P®É¶¡­pºâ¤W¿é¤J¬Ù¤F¤£¤Ö§xÂZ
·P®¦

TOP

¦^´_  ky2599y

¦û¦ì²Å¸¹ªº¥\¯à¡A·N¦b±j¨îÅã¥Ü«á­±ªº¦r¤¸
Hsieh µoªí©ó 2011-7-15 21:20



    §ÚÀ´¤F¡A·PÁª©¥Dªº±Ð¾Ç¡AÁÂÁÂ
Kenny

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD