Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
extract time from text import
When I import a text selection, the date format gets changed from 1316:10 to
1316:10:00. It looks like Excel is trying to interpret the time format to a date and time format. I've tried using the LEFT function to extract only the 1316, but excel has already converted the time to its time and date format. A watch is added to the VBA code to see how excel is intrepretting it. 1316:10 gets converted to 165 or 2/23/1900 8:10:00 PM. The question is, how do I extract only the hh:mm or hh:mm:ss? Thanks in advance, Pete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
refer a cell text in b1 and extract remaing text from a1 | Excel Discussion (Misc queries) | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
How do I extract time only in Excel? | Excel Discussion (Misc queries) | |||
How to extract time and date | Excel Discussion (Misc queries) | |||
Add leading 0 to csv import text/time H:MM | Excel Discussion (Misc queries) |