回覆：問Excel
Excel stores dates and times as numbers, with the integers representing days (since 1 january 1900). The decimal part is the fraction of a day.
If your cell has only hh:mm:ss with no day part, (Excel will treat it as that time on 1 January 1900), simply multiply the cell by the number of seconds in a day -- 24*60*60)
EDIT: If your cell might also have a non-zero date component, just to be safe you could use:
=MOD(A1,1)*24*60*60
where A1 is assumed to have your orginal hh:mm:ss data.
注意:本人所發佈的帖子大部份均為轉貼,如本人所發的貼子有任何問題及投訴,如本人所發的貼子有任何法律責任,本人恕不負責!
發表於 
返回列表
