0
I have a spreadsheet with date/time values in UTC that I would like to be displayed to users in their time zone, e.g. the same spreadsheet containing UTC date/time values is provided to users in Australia and England and each user should see the date/time values converted to their local time zone.
I've found many suggestions ranging from hard-coding time offsets in formulas (e.g. B2=A1+(n/24) where n is the time zone offset) up to including a table of daylight saving time changes in the spreadsheet, but none of these approaches will allow users in different time zones to see the times as local times for them, not to mention the difficulty of maintaining up to date time zone offset and daylight saving change information.
Excel only uses the computer's system time. You can only control the format of the date and time within Excel. If you need UTC set the time zone on the system to UTC. If you are converting a raw file, one not generated by the Date function within excel, its up to you perform the offset calculations. – Ramhound – 2016-12-07T03:26:00.400
Thanks, I was afraid this was the case. Do you have a source confirming this that we could link to? – Kendall Lister – 2016-12-07T04:06:01.060
Microsofts own website – Ramhound – 2016-12-07T04:19:15.523
1Any chance of being more specific? I might find an alternative approach if you can point me to the particular piece of documentation you're referring to. I haven't been able to find such a page myself. – Kendall Lister – 2016-12-21T00:30:39.817
I wipe my research I did over a week ago – Ramhound – 2016-12-21T03:08:55.533