GMT/UTC to local time conversion

[tuspilica]

Hi guys,

I'm trying to convert from GMT time to local time. I have the a column where my data has the format:
19-01-2019,07:20:23

I applied the formula:
=A2-(5/24)
to calculate the local time but i got the error: There's something wrong with the way your formula is typed. Or, there's something wrong with the cells you are referencing."

I tried to modify the cell format, replaced comma with space, dashes with slash ... no success. The format remains the same and the error is present.
I've added a Custom format: dd/mm/yyyy hh:mm:ss
I applied it to entire column, but there is no change, the data remains with the same format 19-01-2019,07:20:23
It works if i'm typing the full date manually, but the table comes populated with these data
Any help please?

Thank you

 

[MARK858]

What does the formula =ISNUMBER(A2) return?

 

[Logit]

.

=RIGHT(A2,8)-5/24

Format cell/s : TIME 1:30 pm

 

[tuspilica]

I found out that the date & time data from my entire time stamp column is actually "text" (from a .CSV file).

19-01-2019,07:20:23

So, I have to find the easiest way to convert this text data into time format, then to apply the GMT correction.

Is there a way to do this without using macros?

 

[MARK858]

I found out that the date & time data from my entire time stamp column is actually "text" (from a .CSV file).

n

That is why I asked the question in post number 2
Try selecting the column and then doing a Find/Replace with a comma in the Find what box and and a single space in the Replace with box (making sure that match entire cell contents is not checked).

 

[tuspilica]

n

That is why I asked the question in post number 2
Try selecting the column and then doing a Find/Replace with a comma in the Find what box and and a single space in the Replace with box (making sure that match entire cell contents is not checked).

Thank you Mark!
problem resolved. Appreciating your time and help!