- ©«¤l
- 25
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 36
- ÂI¦W
- 0
- §@·~¨t²Î
- 64¦ì¤¸§@·~¨t²Î*64«¬³B²z¾¹
- ³nÅ骩¥»
- WINDOWS10®a¥Îª©
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2019-3-13
- ³Ì«áµn¿ý
- 2019-9-3
|
¦^´_ 6# ML089
½Ð°ÝML089¦Ñ®v:
¥H¤U¤TÓ¨ç¼Æ,¦pªG¦bÄæ¦ì¦³§Únªº¸ê®Æ,´N³£¨S°ÝÃD,¦ý¦pªG¨S¦³§Únªº¸ê®Æ®É,´N·|¥X²{#N/A,Äæ¦ì¥i¥HÅã¥ÜªÅ¥Õ¶Ü?ÁÂÁ±z
¶}©l®É¶¡
TEXT(-LOOKUP(,-MID(F2,FIND("/",F2,FIND("<¶}©l>",F2))+1,ROW($F:$F))),"yyyy/m/d hh:mm")
¶}©l¤º®e
TRIM(LEFT(SUBSTITUTE(MID(G4,FIND("<¶}©l>",G4)+4,99),"/",REPT(" ",99)),99))
µ²§ô®É¶¡
IFERROR(TEXT(-LOOKUP(,-RIGHT(F2,ROW($F:$F))),"yyyy/mm/dd hh:mm"),"") |
|