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 com...
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
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
That would be complicated; I'll leave that for someone else.
- Thanks.