View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ASP1000 ASP1000 is offline
external usenet poster
 
Posts: 1
Default Accurate time based analysis

Hi,

I am trying to analyse some data which has been recorded with a timestamp.
the problem is that Excel is not able (as far as I am aware) to read the time
accurately ebnough. The data I have is accurate to 100 nano seconds, i.e. the
data is in format HH:MM:SS.mmmuuun. So far I have been able to get the format
MM:SS.mmm, but this is not good enough. Does anyone know of a way to get the
more accurate format?
--
asp