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

=NOW()

format to ss.000


"Dan" wrote:

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.

On Jan 21, 11:15 am, Dan wrote:
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

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.

On Jan 21, 11:15 am, Dan wrote:
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

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.

--
Cheers,
Shane Devenshire


"Dan" wrote:

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

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.
--
David Biddulph

"Dan" wrote in message
...
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

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.

--
Cheers,
Shane Devenshire


"Teethless mama" wrote:

=NOW()

format to ss.000


"Dan" wrote:

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

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.
--
David Biddulph

"ShaneDevenshire" wrote in
message ...
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.

--
Cheers,
Shane Devenshire


"Teethless mama" wrote:

=NOW()

format to ss.000


"Dan" wrote:

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