» 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:
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Advanced modelling in finance using Excel and VBA
- Harry Potter and the Order of the Phoenix (Book 5)
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Marketing Plan: A Handbook with Marketing Plan
- Dictionary of Finance and Investment Terms
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
