May 28 2020 11:04 AM
Hello. I installed a XML file into Excel so I could read it easier, I'm a novice. However, when I did the date/time field did not carry over to a readable format. Please see screen shot. Would anyone know how to convert this? I have tried a few schemas like yyyy-mm-ddThh:mm:ss+/-hh:mm, but nothing is working. Thank you ahead of time.
May 28 2020 12:23 PM - edited May 28 2020 12:23 PM
It looks like you have 13-digits UNIX timestamps, i.e. with milliseconds. You may convert it on Windows datetime in Excel as below, using that formula and applying custom format to the result
=(((A1/1000/60)/60)/24)+DATE(1970,1,1)
May 28 2020 02:13 PM
May 28 2020 02:26 PM
@wendi78 , you are welcome, glad to help