Convert Timestamps with Excel or Google Sheets

Often you get a timestamp that cannot be interpreted by whatever system you are bringing it into. You can use Python to convert it, alternatively use google sheets or excel you to convert it using the functions: Date() + Mid(). Here I used: =DATE(MID(A10,1,4),MID(A10,6,2),MID(A10,9,2))+(MID(A10,12,8))+0.16666666

BTW - Tableau and some other BI tools have no trouble reading the Timestamp as it is - in Tableau - just make sure you select 'Date & Time' as the field-type if it is not automatically detected.

[prestonlambeth]

Exactly what I needed, thank you so much!