Thread: millisecond
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] reitanospa1@yahoo.com is offline
external usenet poster
 
Posts: 38
Default millisecond

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