Using Microsoft Exchange Online Message Trace with downloaded results are in UTC in a CSV file.
ref: https://docs.microsoft.com/en-us/exchange/monitoring/trace-an-email-message/run-a-message-trace-and-view-results
origin_timestamp
2019-06-29T00:11:45.8851621Z
yyyy-mm-ddThh:mm:ss:ttttZ
To convert in Excell from UTC to PST is - 7 hours
=DATEVALUE(LEFT(A2,10))+TIMEVALUE(MID(A2,12,10))-TIME(7,0,0)
No comments:
Post a Comment