Download chart data time GMT

[jameszahary]

UTC time convert to IST time

Update for new date time format [image] =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