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

[µo°Ý] Â^¨ú¯S©w¤å¦r«á­±ªº¸ê®Æ

[µo°Ý] Â^¨ú¯S©w¤å¦r«á­±ªº¸ê®Æ

­nÂ^¨ú<µ²§ô>¤§«áªº¤é´Á»P®É¶¡

§Ú¤Uªº¨ç¼Æ¬°:
=RIGHT(F5,16)
´N¥i¥X²{§Ú­nªº2019/03/15 10:30

½d¨Ò:
FÄæ¦ì
©K¡B©K¡B©K©K©K¡A
Áà¤pÀn§rÁà¤pÀn¡A
»L¨àµuµu¸}´x¤j¡A
ªøªø²ä¤l«ó¼L¤Ú¡A
¨«°_¸ô¨Ó·n§r·n¡A
·R¨ìªeÃä¥hª±­A¡A
³ïÄVÁö¤pÁn­µ¤j¡A
¥i¬O¥u·|©K©K©K¡C

<µ²§ô>2019/03/15 10:30
_______________________________________

¦pªG½d¨Ò¨S¦³¥X²{<µ²§ô>2019/03/15 10:30,Äæ¦ì´N¥X²{
=>³ïÄVÁö¤pÁn­µ¤j¡A
¥i¬O¥u·|©K©K©K¡C


FÄæ¦ì
©K¡B©K¡B©K©K©K¡A
Áà¤pÀn§rÁà¤pÀn¡A
»L¨àµuµu¸}´x¤j¡A
ªøªø²ä¤l«ó¼L¤Ú¡A
¨«°_¸ô¨Ó·n§r·n¡A
·R¨ìªeÃä¥hª±­A¡A
³ïÄVÁö¤pÁn­µ¤j¡A
¥i¬O¥u·|©K©K©K¡C

½Ð°Ý§Úªº¨ç¼ÆÀ³¸Ó«ç»ò¤U©O?ÁÂÁÂ

¦^´_ 2# hcm19522


  ÁÂÁ±z¡A§Ú¨S»¡²M·¡¡A§Úªº¸ê®Æ³£¦b¦P¤@Äæ¦ì¸Ì­±¡A§Ú¨Ï¥ÎML089¦Ñ®vªºªº¨ç¼Æ´N¥i¥H¤F
±zªº¸Ñµª§Ú¤]·|µ§°O°_¨Ó¡A«D±`·PÁÂ

TOP

=IFERROR(TEXT(-LOOKUP(,-RIGHT(F5,ROW($1:$20))),"yyyy/mm/dd hh:mm"),"")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : «H¤ß¡B¼Ý¤O¡B«i®ð¤TªÌ¨ã³Æ¡A«h¤Ñ¤U¨S¦³°µ¤£¦¨ªº¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD