Updating date and time using computer time zone settings

%3CLINGO-SUB%20id%3D%22lingo-sub-2204882%22%20slang%3D%22en-US%22%3EUpdating%20date%20and%20time%20using%20computer%20time%20zone%20settings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2204882%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%20I%20have%20an%20excel%20file%20with%201%20x%20date%20column%20and%201%20x%20time%20column%20set%20as%20UK%20time%20for%20event%20in%20the%20future.%3C%2FP%3E%3CP%3EI%20want%20theses%20columns%20to%20update%20according%20to%20the%20time%20zone%20settings%20the%20user%20has%20on%20their%20computer.%3C%2FP%3E%3CP%3ECan%20I%20take%20those%20columns%20and%20using%20a%20formula%20have%20two%20new%20o%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2204882%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2204925%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20date%20and%20time%20using%20computer%20time%20zone%20settings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2204925%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F995268%22%20target%3D%22_blank%22%3E%40DennisMetro%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20the%20attached%20version.%20I%20used%20a%20lookup%20table%20with%20time%20zones.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hi. I have an excel file with 1 x date column and 1 x time column set as UK time for event in the future.

I want these columns to update according to the time zone settings the user has on their computer.

Can I take those columns and using a formula have two new columns which update to local (user's) time?

6 Replies

@DennisMetro 

 

See the attached version. I used a lookup table with time zones.

Thanks Hans. I think maybe I did not make myself clear. If, foe example, someone open the file in Bangkok then what I want that person to see is for 1st game
Sat, 12 June, 02:00, 2nd game Sat, 13 June, 20:00, and so on. If they open the file in HongKong then 1st game Sat, 12 June, 03:00, 2nd game Sat, 13 June, 21:00; if they open it in any location it changes the UTC time in London to their date/time depending on their location (computer time zone). Thank you again for any assistance and sorry if I was unclear. Dennis

@Hans Vogelaar 

As a comment, in general it will be nice to add

- US and Europe change it at different time

- Russia doesn't change the time at all, thus UTC+3 at winter and UTC+2 at summer

Hi Sergei, For this case it does not matter about winter / summer time as it is all in summer.

@DennisMetro 

That would be complicated; I'll leave that for someone else.