Forum Discussion
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 a way in Excel to make column C automatically display the timestamps for those locations (B) at the time of the timestamps in column A?
1 Reply
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.
