UTC time convert to IST time

I think that is a feature, not a bug :grinning:
Once you hit the database, you need one time, not all these timezones, with and without adjustments.

When you download the csv, and are analyzing with Excel, you can use the following to convert:

=(-6*3600+MID(A2,17,2)*3600+MID(A2,20,2)*60+MID(A2,23,2))/(24 * 3600)

The -6 is for Mountain Daylight Time.
For Indian Standard Time, change the -6 to +5.5, I think.

2 Likes