Forum Discussion
animenua
Aug 08, 2021Copper Contributor
timestamp, location, local time
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 the locations (cities+countries+zipcodes) all around the globe. Is there ...
Riny_van_Eekelen
Aug 09, 2021Platinum Contributor
animenua As far as I know, Excel has no automatic function for world times, but you can write a formula for it, provided you know your own time zone and that of the other locations, relative to GMT. It could look like this:
Now, how to get these time zones into Excel is another question, but I trust you are able to find them in one of many on-line resources. And, obviously, you'll have to take daylight saving time into account as well.