Trouble importing data froma text file and converting to date format in excel
Posted on 2011-02-17
I have a textfile with data that I want to import in to excel. For some reason the text format imports funky looking and I cannot convert to a date and time value (end goal is to do a count for each hour period and each day of the week)
This is the text file
So any guidance on how to import it to a basic time (hh:mm) and date mm-dd-yy is greatly apperciated...once I can import it properly then I want to seperate the two in to different colums for analysis.