I am exporting some logs from Microsoft Azure to an Excel CSV file and I would like to convert UTC time that is placed in cell A2 to AEST and place in B2.
I would prefer not to have to use a third party tool, so if there is a formula I can use would be great.
The Date Value in cell A2 look like this "2020-02-11T22:49:56.1699545Z" and I would like it to look like this in Cell B2 "11/02/2020 22:49:56"
Furthermore, if this cant be done is there a way that I can change the timezone in Azure so when I export the logs the dates are shown in EST ?
Any help would be appreciated.