» Show the time in the Format hh:mm:000 using VBA
CATEGORY - Date & Time in VBA
VERSION - All Microsoft Excel Versions
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
Book Store:
Recommended Books:
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Business Plans For Dummies®
- Marketing Plan: A Handbook with Marketing Plan
- Microsoft Word Version 2002 Inside Out
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Accounting for Dummies
No comments have been submitted.
