Google sheet formula to convert a ISO86001 string to a date time:
Input: 2022-06-23T16:31:34.036000+00:00 (cell A2)
Formula: SUM(SPLIT(left(A2,len(A2)-6),"T"))
Output: (a properly-formatted datetime)
Google sheet formula to convert a ISO86001 string to a date time:
Input: 2022-06-23T16:31:34.036000+00:00 (cell A2)
Formula: SUM(SPLIT(left(A2,len(A2)-6),"T"))
Output: (a properly-formatted datetime)