Auto Formatting hours of .csv file

[The Rook]

I have a .csv file that is populated with hours (for example 28:53 when open
as text file)
When I open it in excel it automatically formats any hours that exceed 24:00
as a time & date (for example 28:55 imports 01/01/1900 07:54:00, and when I
format it as [h]:mm:ss it displays 31:54:00)

If the data reads less than 24:00 ie 18:45 it will display 18:45

How caN i COEERCT THIS?

 

[Gary''s Student]

Take control of the import:

1. Open Excel
2. Data > Import External Data > Import Data and then tell the Wizard which
file to open

The Wizard will allow you to specify the field formats.

 

[The Rook]

WORKED A TREAT THANKS

Take control of the import:

1. Open Excel
2. Data > Import External Data > Import Data and then tell the Wizard which
file to open

The Wizard will allow you to specify the field formats.

--
Gary''s Student - gsnu200853

I have a .csv file that is populated with hours (for example 28:53 when open
as text file)
When I open it in excel it automatically formats any hours that exceed 24:00
as a time & date (for example 28:55 imports 01/01/1900 07:54:00, and when I
format it as [h]:mm:ss it displays 31:54:00)

If the data reads less than 24:00 ie 18:45 it will display 18:45

How caN i COEERCT THIS?