We want to import .CSV files into Ecel, and graph the data. Excel seems to
recognize time formats that include seconds, but not milliseconds. How can we
format time to handle milliseconds.

[hh]:mm:ss.000 , for example
--
David Biddulph

"Bazza" wrote in message
...
We want to import .CSV files into Ecel, and graph the data. Excel seems to
recognize time formats that include seconds, but not milliseconds. How can
we
format time to handle milliseconds.

Hi,

I do a similar thing. My time data are imprted as times, so assuming two
times are in A1 and A2, the time difference in milliseconds is =1000*(A2-A1)
if you give your cell a custom number format of [s]

Dave

url:http://www.ureader.com/msg/10296287.aspx