Change time to local

Home Forums TAGSExplorer Questions/Issues Change time to local

Tagged: 

This topic contains 2 replies, has 2 voices, and was last updated by  Trendmatcher 6 years, 1 month ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #272

    Trendmatcher
    Participant

    How can I change the time to local time?

    #273

    mhawksey
    Keymaster

    Hi Willem – The default archive has two date/time columns. created_at is in a string format and is the data as provided by twitter. The time column is in a date/time format and can be displayed as a local time by adjusting the spreadsheet timezone from the File > Spreadsheet settings menu. Changes to the timezone only affect new tweets collected in the archive. To adjust existing data there are existing scripts like this one to help http://victorwyee.com/gapps/change-time-zone-for-column-of-time-data-in-google-spreadsheets/

    Best wishes
    Martin

    #274

    Trendmatcher
    Participant

    Ah thanks! I had tried that in the script editor under properties, but this is the place it has to be done, perfect!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.