If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|