Timestamp, location, local time

[terentyev]

I’m creating a spreadsheet with 1000+ rows where in the column A are the timestamps in my local time, and in the column B are many different locations (cities+countries+zipcodes) all around the globe. Is there a way to make column C automatically display the timestamps for those locations (B) at the time of the timestamps in column A?

[sokol92]

Solving such a problem will require the use of fairly large databases, for example: GeoNames