Sub ConvertToTimeFormat(ms As Long) As String
Dim seconds, minutes, hours As Int
seconds = Round(ms / 1000)
minutes = Floor(seconds / 60) Mod 60
hours = Floor(seconds / 3600)
seconds = seconds Mod 60
Return NumberFormat(hours, 1, 0) & ":" & NumberFormat(minutes, 2, 0) & ":" & NumberFormat(seconds, 2, 0)
End Sub