| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show Milliseconds
Thanks!
"Peter T" wrote: not quite ? Why can't I get millisecond results from my VB formula? The Time function returns whole seconds since midnight Dim td As Double td = Time MsgBox td & vbCr & _ td * 24 * 60 * 60 & vbCr & _ CDate(td) Regards, Peter T "Ndel40" wrote in message ... So far to the reply's... no, no and not quite, but thanks! I can get milliseconds to show using standard excel formulas and formatting the cell hh:mm:ss.000 Excel Formula... =TEXT(TIME(18,8,0)-TEXT(NOW(),"hh:mm:ss.000"),"hh:mm:ss.000") Results in... 10:27:49.580 Why can't I get millisecond results from my VB formula? ntime = Time Range("e7").Value = Format(ntime, "hh:mm:ss.000") OR StopTime = TimeSerial(15, 15, 15) myTime = Time ntime = Format(myTime - StopTime, "hh:mm:ss.000") Thanks, Nick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hh:mm:ss AND Milliseconds? | Excel Discussion (Misc queries) | |||
| Show Milliseconds | Excel Programming | |||
| Working With Times / Milliseconds | Excel Worksheet Functions | |||
| Milliseconds in Excel | Excel Programming | |||
| Milliseconds In VB | Excel Programming | |||
Hybrid Mode
