Importing csv data that is time based

  • Thread starter Thread starter BP
  • Start date Start date
B

BP

I have an application that produces values as time based (AMB Orbits - car
racing software) that you can export laptimes as a csv file.

Then I want to import that data in excel. However, the only options when
importing the laptimes is general or text (other than date) which loses the
time format and makes analysing the data useless.

Does anyone know how to set up excel so that the time based format can be
retained when importing

Thanks,
Brett
 
BP said:
I have an application that produces values as time based
(AMB Orbits - car racing software) that you can export laptimes
as a csv file.

Then I want to import that data in excel. However, the only
options when importing the laptimes is general or text (other
than date) which loses the time format and makes analysing the
data useless.
Click to expand...
....

What do your time formats look like? When I import fields in hh:mm:ss
format, Excel has no trouble importing them as times.
 
Hi

It may be worth renaming the .csv to .txt When you try to open this in
Excel, the Text Import Wizard will run, allowing you more flexibility in
deciding how Excel will treat each field.
 
Back
Top