Add Timezone of the City to the sheet.
Status: Closed · Asked by sourav04 on · 0 views
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.
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.