Auto Formatting hours of .csv file
 

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?

Auto Formatting hours of .csv file
 

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


"The Rook" wrote:

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?

Auto Formatting hours of .csv file
 

WORKED A TREAT THANKS

"Gary''s Student" wrote:

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


"The Rook" wrote:

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?