how to convert time zone of a datetime in google sheets-CodePudding

Home > Net > how to convert time zone of a datetime in google sheets

how to convert time zone of a datetime in google sheets

Time：06-28

I have a column, in which datetime in text format "2022-04-12 07:09:10 UTC". I want to change this into IST time zone and convert it into date format only

CodePudding user response：

You'll need to extract the date and time then add on 5h30m. From there you can either wrap it with INT or format the column to show just the date. For the one below, I used INT, which will strip the time after it is converted.

=ARRAYFORMULA(
  IF(ISBLANK(A2:A),,
   REGEXREPLACE(A2:A,"UTC","") 
   TIME(5,30,0)))

Page link：https//www.codepudding.com/net/456854.html

Prev:Convert a conditional formatting formula into an ARRAYFORMULA to display text on first occurrence of

Next:Google Sheets, if else, statement inoperative

Tags：

google-sheets

google-sheets-formula

Links：
CodePudding