How do you format time to handle microseconds

[Bazza]

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.

 

[David Biddulph]

[hh]:mm:ss.000 , for example

 

[Dave Curtis]

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

Dave

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