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