Sample retuned from AQT:
2015-11-20-15.00.00.000000
Paste above into Excel, and then:
=DATEVALUE(LEFT(SUBSTITUTE(L3,”-“,”/”),10))+TIMEVALUE(MID(SUBSTITUTE(L3,”.”,”:”),12,8))
with milliseconds:
=DATEVALUE(LEFT(SUBSTITUTE(AJ207,"-","/"),10))+TIMEVALUE(MID(SUBSTITUTE(AJ207,".",":"),12,8) & RIGHT(AJ207,7))