1

I have a col on googlesheet, that I need convert to date time with query function.

Column A Column B
nome1 2022-11-17T13:41:47.431Z
name2 2022-11-17T13:41:47.431Z
Column A Column B
nome1 2022-11-17 13:41:47
name2 2022-11-17 13:41:47
player0
  • 124,011
  • 12
  • 67
  • 124

1 Answers1

0

try:

=INDEX(QUERY({A1:A, TEXT(REGEXREPLACE(B1:B,
 "[TZ]", " "), "e-mm-dd hh:mm:ss")}))

enter image description here

player0
  • 124,011
  • 12
  • 67
  • 124