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

[µo°Ý] ¦p¦ó¨ú±o¦P¤@Àx¦s®æ¤º¤U¦æªº®É¶¡¨Ó¶i¦æ¤ñ¸û

[µo°Ý] ¦p¦ó¨ú±o¦P¤@Àx¦s®æ¤º¤U¦æªº®É¶¡¨Ó¶i¦æ¤ñ¸û

¦U¦ì«e½ú
·q½Ð«üÂI¤è¦V
[A5] ¤º®e 2010/02/16 & chr(10) & hh:mm
¡]Àx¦s®æ¤º²Ä¤@¦æ "2010/02/16" ¤é´Á¡A²Ä¤G¦æ "hh:mm" ®É¶¡¡^
±ý¨ú±ohh­È¨Ó¤ñ¸û¡G>= 12 [B5]=PM, AM
½Ð°Ý¦p¦ó¨ú±ohh­È

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

¦^´_ 1# b9208


k = CDate([A5]) - Int(CDate([A5]))
[B5] = IIf(k >=0.5, "PM", "AM")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh

«D±`·PÁª©¥D«ü¾É
¸ê®Æ¤w§¹¦¨
100 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD