timestamp, location, local time

%3CLINGO-SUB%20id%3D%22lingo-sub-2625583%22%20slang%3D%22en-US%22%3Etimestamp%2C%20location%2C%20local%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2625583%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20creating%20a%20spreadsheet%20with%201000%2B%20rows%20where%20in%20the%20column%20A%20are%20the%20timestamps%20in%20my%20local%20time%2C%20and%20in%20the%20column%20B%20are%20the%20locations%20(cities%2Bcountries%2Bzipcodes)%20all%20around%20the%20globe.%20Is%20there%20a%20way%20in%20Excel%20to%20make%20column%20C%20automatically%20display%20the%20timestamps%20for%20those%20locations%20(B)%20at%20the%20time%20of%20the%20timestamps%20in%20column%20A%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2625583%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2626026%22%20slang%3D%22en-US%22%3ERe%3A%20timestamp%2C%20location%2C%20local%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2626026%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1123471%22%20target%3D%22_blank%22%3E%40animenua%3C%2FA%3E%26nbsp%3BAs%20far%20as%20I%20know%2C%20Excel%20has%20no%20automatic%20function%20for%20world%20times%2C%20but%20you%20can%20write%20a%20formula%20for%20it%2C%20provided%20you%20know%20your%20own%20time%20zone%20and%20that%20of%20the%20other%20locations%2C%20relative%20to%20GMT.%20It%20could%20look%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-08-09%20at%2006.01.54.png%22%20style%3D%22width%3A%20417px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F301665iA5693F6347F74450%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-08-09%20at%2006.01.54.png%22%20alt%3D%22Screenshot%202021-08-09%20at%2006.01.54.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ENow%2C%20how%20to%20get%20these%20time%20zones%20into%20Excel%20is%20another%20question%2C%20but%20I%20trust%20you%20are%20able%20to%20find%20them%20in%20one%20of%20many%20on-line%20resources.%20And%2C%20obviously%2C%20you'll%20have%20to%20take%20daylight%20saving%20time%20into%20account%20as%20well.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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:

Screenshot 2021-08-09 at 06.01.54.png

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.