| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I import from csv file without auto formatting? | Excel Discussion (Misc queries) | |||
| Can I auto save to a separate file?(not the file I am working in) | Setting up and Configuration of Excel | |||
| Conditional formatting on overtime hours | Excel Worksheet Functions | |||
| auto save excel file every 10 minutes to its original file name | Excel Discussion (Misc queries) | |||
| Formatting Hours and Minutes | Excel Discussion (Misc queries) | |||
![The Rook[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
