how to Convert EST time to IST time in excel

Question

I have a requirement where I get the data in Excel column like "7/12/2017 3:00:00 AM" (EST timing). Now I need to convert it into IST time of the same format.

Answer 1

Use the following calculation since Indian Standard Time is 9 hours and 30 minutes ahead of Eastern Time.

=A1+TIME(9,30,0)