Reply To: Change time to local

Home Forums TAGSExplorer Questions/Issues Change time to local Reply To: Change time to local

#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