I have the following timestamps from an API call:
2022-05-22T13:53:42.010238Z
2022-05-22T11:53:30.910039Z
2022-05-22T11:46:43.904101Z
2022-05-22T11:46:27.815341Z
2022-05-22T11:46:12.581602Z
2022-05-22T11:41:56.246782Z
2022-05-22T11:41:39.443423Z
I would like to convert them into readable dates example: 22/05/2022-13:53:42 and also add +3 hours to them.
>Solution :
You can try below formula-
=SUM(SPLIT(SUBSTITUTE(A1,"Z",""),"T"))+TIME(3,0,0)
