convert text timestamp into correct date and time in google sheets

0
votes

I have this text timestamp in a google sheets cell and I want to convert it into a correct date time format that google sheets recognizes, while changing the order of year-month-day to day-month-year and adding +1 hour to it with the 24hr format.

From "TEXT formatted" > 2020-02-08 19:00:12

To "DATE-TIME formatted" > 08-02-2020 20:00:12

Could you please suggest a formula?

1
datetimegoogle-sheetsstring-formattinggoogle-sheets-formulanumber-formatting

1 Answers

1
votes

try:

=TEXT(A1+1/24; "dd-mm-yyyy hh:mm:ss")

or you can just do:

=A1+1/24

and then format it as you wish internally like:

0