秒以下化為小數點 (9548)

(A2是數字時間) C2=RIGHT(SUBSTITUTE(TEXT(100&A2,"h:mm.ss"),":",".",2),8)

数据全文本=SUBSTITUTE(A2,":",".",2)