| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA adding time in milliseconds
I have this:
Now() is current time. Function myTime() Dim t As Variant t = Now() + TimeValue("00:00:20") myTime= Format(t, "hh:mm:ss") & "." & Right(Format(Timer, "#0.00"), 2) End Function This adds 20 seconds to now() I require to add milliseconds to Now() rather than seconds to get mytime(). How can this be done? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding and Subtracting a Time with MilliSeconds | Excel Worksheet Functions | |||
| Time milliseconds format | Excel Programming | |||
| Comparing time values which have milliseconds in them e.g 10:20:30 | Excel Discussion (Misc queries) | |||
| Can time be measured to milliseconds? | Excel Programming | |||
| Grab Time with milliseconds included in VBA | Excel Programming | |||
Threaded Mode
