View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Accurate time based analysis

I'm not sure if Excel will retain the accuracy, as it is limited to 15
digit precision (and times are stored internally as fractions of a 24-
hour day).

If it does, you can multiply by 24, and by 60 and by 60 again, and you
would have the time in seconds - format the cell as a number with 7
dp.

Hope this helps.

Pete

On Jun 27, 5:20*pm, ASP1000 wrote:
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