Forum Discussion
Updating date and time using computer time zone settings
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
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.
- 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. DennisThat would be complicated; I'll leave that for someone else.
