CODEWITHSUNDEEP
datetimegoogle-sheetsstring-formattinggoogle-sheets-formulanumber-formatting
Mauriziotis
Mauriziotis

Reputation: 19

convert text timestamp into correct date and time in google sheets

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?

Upvotes: 1

Views: 5182

Answers (1)

player0
player0

Reputation: 1

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

Upvotes: 2

Related Questions