Excel formula to convert EST date time into IST date time

excelexcel-formula

I need to convert a EST date time column of excel into IST date time.

For example:

A1 column(EST) : 11/28/2015 11:38 PM

then I want the result to be in IST (11/29/2015 10:08 AM)

I tried some google search and got this below formula but its not giving result.

=IF(A1-TIME(10,30,0)<0,1+A1-TIME(10,30,0),A1-TIME(10,30,0))

Best Answer

The code =IF(A1-TIME(10,30,0)<0,ABS(1+A1-TIME(10,30,0)),A1-TIME(10,30,0)) works if your cell is properly formatted (the second last time formatting type)

Related Topic