|
本帖最后由 t13564865256 于 2015-8-31 14:44 编辑
最佳答案的毫秒ss,取值有问题
当毫秒是很小的小数时,会转用科学计数,取前四位就导致结果不正确
将程序改成以下,就完美解决了。
Sub ttt()
Dim tt As Single
Dim h As String
Dim m As String
Dim s As String
Dim ss As String
Dim detelR As Long
tt = Timer
h = Format(Int(tt / 3600), "00")
m = Format(Int((tt - 3600 * h) / 60), "00")
s = Format(Int(tt - h * 3600 - m * 60), "00")
ss = Format(Application.RoundDown(tt - Int(tt), 3), ".000")
detelR = ThisWorkbook.Sheets(1).Range("A62566").End(xlUp).Row
If detelR >= 19 Then
ThisWorkbook.Sheets(1).Range("A2:B" & detelR).ClearContents
detelR = 1
End If
ThisWorkbook.Sheets(1).Cells(detelR + 1, "A") = h & ":" & m & ":" & s & ss
End Sub
|
|