Search code examples
exceltexttimeimportexcel-2008

How do I import text into time format?

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

Solution

  • 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.