Reply To: Change time to local
Home › Forums › TAGSExplorer Questions/Issues › Change time to local › Reply To: Change time to local
January 6, 2015 at 9:48 am
#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