View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dan dan is offline
external usenet poster
 
Posts: 866
Default Formating a timestamp as a date and time.

I have imported some data into excell and it is currently looks like this
2006-09-26-11.16.38.902000 I am trying to compare ir get the difference
between two of these timestamps but excell doesn't receognize this format.
What is the easiest way to make this timestamp work? I am using excel 2000.