Date format: string to Data with GMT 5+30

[shvkumara]

Hi,

Thanks for the help which you are going to offer me.

My problem is I have a list of date values in the format "Sun, 11 Nov 2018 23:30:46 GM",, But I want to convert it to IST i.e GMT 5:30. The expected output is "11/12/2018 5:00". I have tried but couldn't get it done in one formula.

Some of the list
Sun, 11 Nov 2018 18:56:12 GMT
Sun, 11 Nov 2018 16:57:19 GMT

thanks
SHiva

 

[steve the fish]

Hi. In order to do that we would need to know if the date/time you have in your cell is text or a number. Lets say your date is in cell A1. What does the following produce?

=ISNUMBER(A1)

 

[steve the fish]

Assuming its text not number:

=TRIM(REPLACE(SUBSTITUTE(A1,"GMT",""),1,FIND(",",A1),""))+TIME(5,30,0)