1 2 3 4 5 6 7 8 9 10
|
Public Function TempsNbEnTexte(TempsNb As Double)
Dim Heure As Long, Minute As Long, Seconde As Long, Miliemme As Long
Heure = CLng(Int(TempsNb / 3600000))
Minute = CLng(Int((TempsNb - Heure * 3600000) / 60000))
Seconde = CLng(Int((TempsNb - Heure * 3600000 - Minute * 60000) / 1000))
Milliemme = CLng(TempsNb - Heure * 3600000 - Minute * 60000 - Seconde * 1000)
TempsNbEnTexte = Format(Heure, "00") & ":" & Format(Minute, "00") & ":" & Format(Seconde, "00") & ":" & Format(Milliemme , "000")
End Function |
Partager