Mar 12 2021 02:50 AM - edited Mar 12 2021 02:52 AM
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?
Mar 12 2021 03:21 AM
Mar 12 2021 03:35 AM
Mar 12 2021 03:36 AM
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
Mar 12 2021 03:38 AM
Mar 12 2021 03:43 AM
That would be complicated; I'll leave that for someone else.