主題: 時間在Excel的函數與VBA問題
瀏覽單個文章
dunson
Basic Member
 

加入日期: Sep 2003
您的住址: 台灣
文章: 14
=TEXT(SUBSTITUTE(B5,"-",""),"00-00-00 00\:00-00.0")
2011-12-12 00:42-49.0
=TEXT(SUBSTITUTE(B5,"-",""),"00-00-00 00\:00-00")
2011-12-12 00:42-49
後面多.0
舊 2012-01-01, 03:03 AM #3
回應時引用此文章
dunson離線中