Reply To: Change time to local

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



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

Best wishes