How do I import text into time format?

excel text time import excel-2008
notMyScreenName picture notMyScreenName · Dec 17, 2010 · Viewed 13.4k times · Source

I have text files from a data logger in a format like this

hh:mm, Data, Data

that I need to import into Excel.

I cannot for the life of me figure out how to get Excel to import the hh:mm part as (24 hour format) time instead of text. Is it possible? If not is there any straight-forward way of converting a column of hh:mm text into Excel's time format? (I know I can write a conversion formula, but there must be something built-in already right?)

Excel 2008 on OS X

Answer

Alex Andronov picture Alex Andronov · Dec 18, 2010

Not sure there is a good way to do this with a button but

=TIMEVALUE(A1)

where A1 is your date should do the trick.

Related questions

Insert characters into string in different locations

I have a string which looks like this 20141007023617. And I would like to make it look like this 2014-10-07T02:36:17Z. The T and Z are very important for me. So I would like to insert them as well. …

Read More
How do I Replace a String in a Line of a Text File Using FileSystemObject in VBA?

I am trying to use FileSystemObject methods to find a specific line in a text file, and within that line replace a specific string. I am relatively new to this, as my current code has excel open the text file …

Read More
Python Throwing "'utf8' codec can't decode byte 0xd0 in position 0" Error

I am trying to load a currently existing worksheet and import the text file (comma separated values) screenshot shown below, Excel Sheet: Text File: I am using the code shown below: # importing necessary modules for performing the required operation import …

Read More