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?
|