» Show the time in the Format hh:mm:000 using VBA
CATEGORY - Date & Time in VBA
VERSION - All Microsoft Excel Versions
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
Book Store:
Recommended Books:
- Microsoft Windows XP Registry Guide
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Financial Statement Analysis with S&P insert card
- Marketing Plans That Work, Targeting Growth and Profitability
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
No comments have been submitted.
