How do you format time to handle microseconds
 

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.

How do you format time to handle microseconds
 

[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.

How do you format time to handle microseconds
 

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