201911141707时分秒转换 (6288)

 

C3=-LOOKUP(,-RIGHT("0:0:"&SUBSTITUTE(LEFT(A3,LEN(A3)-2),"'",":"),ROW($1:$9)))*24

方式二=-LOOKUP(,-({"","0:","0:0:"}&SUBSTITUTE(SUBSTITUTE(A3,"''",),"'",":"))*24)

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank





Powered by Xuite