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

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