Are you using Excel to read your exported analytics and having trouble reading the date/time column?
To format the date/time column in the CSV exports when using Excel do the following steps:
On the "Home" ribbon go to "Format" and select "Format Cells"
Then choose "Date" and select the format highlighted below.
Now you will see delightfully human-readable dates and times.
Awesome