Converting UTC Date?

Dec 10, 2010 at 4:16 PM

Good morning! Quick question: Is there any way we can convert the UTC date columns and/or change the setting (which used to be much easier to understand before the UTC conversion)?  It's much appreciated - Thanks!

Dec 10, 2010 at 5:02 PM
Edited Dec 10, 2010 at 5:13 PM

Hello, Josh:

I assume you are talking about the Relationship Date (UTC) or Joined Twitter Date (UTC) columns on NodeXL's Import from Twitter features.  If so, I haven't changed anything there except to add "UTC" to the column headings to note that the dates are in UTC.  That's how Twitter provides them, and without the "UTC" suffix they were ambiguous.  I haven't changed the dates themselves.

If you prefer to have the dates in your local time zone, please see "Converting UTC Times to Local Times" at http://excel.tips.net/Pages/T003440_Converting_UTC_Times_to_Local_Times.html.

-- Tony