Add Timezone of the City to the sheet.

[sourav04]

Hi, I have a list of over 200 cities and I want to add their corresponding timezone in the next column in the Google Sheets. Any ideas on how I can go about doing this? I am looking to automate this whole process rather than spending hours searching and adding it.

 

[Pabblymember11]

Hey @sourav04

Regarding your concern, you can establish a "LookUp Table" and manually add the cities with the corresponding timezones.

Please check out the following video tutorial for your better understanding.