UTC time convert to IST time

[jameszahary]

Update for new date time format

=DATE(MID(A2,2,4),MID(A2,7,2),MID(A2,10,2))+(-6*3600+MID(A2,13,2)*3600+MID(A2,16,2)*60+MID(A2,19,2))/(24 * 3600)

This contains time and date in one cell – the -6 is for Mountain Daylight Time zone