Change time to local

[Trendmatcher]

How can I change the time to local time?

[mhawksey]

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

[Trendmatcher]

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

[Author]

Posts