Date Time Format

If your problem doesn't fall into one of the other categories, report it here.

Moderator: Moderators

Post Reply
Talbess
Posts: 5
Joined: Mon Oct 15, 2012 7:28 am

Date Time Format

Post by Talbess »

I downloaded the Web Usage data (Visited Sites) as a CSV file.
The Date Time values in the first column are in some format that Excel (and Talbess) doesn't understand. I know nothing about Unix date time formats but I assume these date times are in some such format.

Can anyone help me with how to make these date time display correctly in a spreadsheet.

My dates are dd/mm

Example
Displayed datetime on status page: 23/10 7:39:07
Displayed datetime in csv file: 1350938347

BTW tried to import the csv file into a Google spreadsheet and it just did nothing.

ispyisail
Moderator
Posts: 5212
Joined: Mon Apr 06, 2009 3:15 am
Location: New Zealand

Re: Date Time Format

Post by ispyisail »

I might have the same problem?

Post Reply