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

milk609609

­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?ÁÂÁÂ

hcm19522

https://blog.xuite.net/hcm19522/twblog/587070099

ML089

=IFERROR(TEXT(-LOOKUP(,-RIGHT(F5,ROW($1:$20))),"yyyy/mm/dd hh:mm"),"")

milk609609

¦^´_ 2# hcm19522


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