millisecond

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

can I display millisecond in Excel.
I tried =SECOND(NOW()) and changing the format to ss.000
but still did not work.
Any idea?
Dan
 
All time is considered a fraction of a day in Excel:
1 = one day, 24 hours
..5 = 12 hours
etc. down to 10 decimal places.
I haven't done the math, but is shouldn't be difficult.
 
Excel treats time as a fraction of a day. I haven't done the math, but
it should be simple:
1 = 24 hours
..5 = 12 hours
etc down to 10 decimal places.
 
Hi,

Try this:

=MOD(60*MOD(24*MOD(NOW(),1),1),1)*60

And format to numbers. Be aware that the fractional part of now tracks the
part of a day. There are only 10 digits available for this because the first
5 digits are on the left of the decimal and they track the date.

Since the are 60*60*24 =86400 seconds in a day so Excel is limited to the
number of decimals it tracks accurately.
 
Which version of Excel you are using?

In mine (Excel 2003) the Excel Help for the SECONDS function says "Returns
the seconds of a time value. The second is given as an integer in the range
0 (zero) to 59.", so I wouldn't have expected to see milliseconds that way.
I don't think that function has changed significantly between versions, but
your Help should tell you.
 
Hi,

The only problem with this idea is the SS.000 still only display to SS.00.
That is, the last decimal, milliseconds, always displays 0.
 
Yes, the resolution of the NOW() function is one-hundredth of a second.
That's still a lot better than Control colon which works to one minute.
 
Back
Top