Tip Printed from ExcelTip.com
Show the time in the Format hh:mm:000 using VBA


Question:
How can I show fractions of seconds in TimeFormat, so for example: 12:05:456?


Answer:
Enter the following Code with XL5/7 in an ModuleSheet, with XL8 in a general Module. InputSyntax: =milhours(A1)





Place the code below into the standard module



Function milHours(dteTime As Date)

   Dim intSec As Integer

   intSec = Second(dteTime)

   intSec = intSec / 60 * 1000

   milHours = Format(Hour(dteTime), "00") & ":" & _

      Format(Minute(dteTime), "00") & "," & intSec

End Function