Hi All, I import data into excel on a regular basis in a csv format. However when the timestamp is imported it is in a format in which excel cannot recognize.
It looks like this
2012-07-19T23:00:01.01+10
or like this
2012-07-19T23:15:01+10 (milliseconds not in format this time!)
which is year month day hour minutes seconds/milliseconds + gmt offset
I don't need the gmt offset or the seconds or milliseconds which sometimes are not even present.
I have very little excel skill and its way above me. I have been able to strip it down using text to columns but this then puts it into two columns one with the date, the other with the time
Ideally I would like to click on the column and convert all the cells in that column to an excel date/time format or it happen automatically as I import the data
The timestamp is always the A column when imported.
I use a web query like this to import the data http://dbname/archive/fetch?swid=/U4...t/plain&after= 2012-01-01T00:00)
Any help would be much appreciated.
cheers rileyp
Bookmarks