...
Dates will be stored in the YYYY-MM-DD format and time values will all be converted to a canonical UTC timezone in the XML document. Date/Time values will be converted to the XML standard YYYY-MM-DDTHH:MM:SSZ. A quick review of Coordinated Universal Time may prove to be beneficial.
UTC Quick Review
UTC time can be thought of as the time at zero degrees longitude. Timezones around the world are considered to be ahead of or behind the UTC time and are expressed with a plus (+) or minus (-) value from the UTC timezone. This plus or minus value is known as an offset. Here is a list of the UTC Timezones and offsets for your reference. Coordinated Universal Time is expressed using the 24 hour clock. UTC is sometimes referred to as Greenwich Mean Time (GMT), although they differ by fractions of a second. The term Zulu time is used by the aviation industry to refer to UTC.
...
5:30 PM (the next day) (Time in India) = 8:00 AM EDT - (-4 (offset for Zone A) + 5:30 (offset for Zone B)
&_form Tz=<tz>
The browser's time zone can be overidden by appending the &_fomTz=<tz> parameter to your form’s share URL. For Example, the timezone of a Product Order form running in the EDT timezone that has a Order Date /Time control can be changed to the PST timezone by appending the &_formTz=America/Tijuana parameter to the form's share URL. If 7:13 is entered for the time value, the time in the XML document will be stored as if the browser was running in the America/Tijuana timezone. In the example below, the T14:13:00Z represents 7:13 - EDT plus 7 hours which is the offset for the America/Tijuana timezone. See Time Zones for more information.
...
Time and date time values exported to Excel are submitted UTC values from the submission doc. Time data will be displayed in the Excel spreadsheet in UTC format. For Example: The Product Order Spreadsheet shows the data from two customer orders entered at 9:00 AM and 2:30 PM in the Eastern Standard Time Zone. Time data will be converted to UTC and stored in the xml document. Exporting the submissions data to Excel will show the time data converted to UTC as it is in the xml document. See the Order Time column in the image.
