=TEXT(DATE(RIGHT(SUBSTITUTE(LEFT(A1,FIND("月",A1))&"-20"&MID(A1,FIND("月",A1)+2,2),"月",""),4),MID(SUBSTITUTE(LEFT(A1,FIND("月",A1))&"-20"&MID(A1,FIND("月",A1)+2,2),"月",""),FIND("-",SUBSTITUTE(LEFT(A1,FIND("月",A1))&"-20"&MID(A1,FIND("月",A1)+2,2),"月",""))+1,FIND("-",SUBSTITUTE(LEFT(A1,FIND("月",A1))&"-20"&MID(A1,FIND("月",A1)+2,2),"月",""),4)-FIND("-",SUBSTITUTE(LEFT(A1,FIND("月",A1))&"-20"&MID(A1,FIND("月",A1)+2,2),"月",""))-1),LEFT(SUBSTITUTE(LEFT(A1,FIND("月",A1))&"-20"&MID(A1,FIND("月",A1)+2,2),"月",""),FIND("-",SUBSTITUTE(LEFT(A1,FIND("月",A1))&"-20"&MID(A1,FIND("月",A1)+2,2),"月",""))-1)),"yyyy-m-d")&" "&TEXT(SUBSTITUTE(SUBSTITUTE(RIGHT(A1,LEN(A1)-FIND(" ",A1)),".000000000",""),".",":"),"h:mm:ss")