millisecond

[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

 

[Teethless mama]

=NOW()

format to ss.000

 

[reitanospa1]

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.

 

[reitanospa1]

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.

 

[ShaneDevenshire]

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.

 

[David Biddulph]

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.

 

[ShaneDevenshire]

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.

 

[David Biddulph]

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.