excel 日期类型 11/7/2018 4:43:04 PM 转为 2018/11/7 4:43:04 PM
=TEXT(RIGHT(LEFT(W2,FIND(" “,W2)-1),4)&”/" & LEFT(W2,FIND(" “,W2)-6) & MID(W2,FIND(” ",W2),11),“yyyy-MM-dd hh:mm:ss”)
Excel
最新推荐文章于 2024-08-17 06:58:38 发布
excel 日期类型 11/7/2018 4:43:04 PM 转为 2018/11/7 4:43:04 PM
=TEXT(RIGHT(LEFT(W2,FIND(" “,W2)-1),4)&”/" & LEFT(W2,FIND(" “,W2)-6) & MID(W2,FIND(” ",W2),11),“yyyy-MM-dd hh:mm:ss”)