I've created a survey in Survey 123 and have selected DateTime as a field type and am having trouble getting the correct time to show up when I export the collected data to an excel file. In survey 123 i'm seeing the correct time but when i export to excel it shows 5 hours off. I have tried putting the pulldata function into survey 123 but perhaps i'm missing something here. I've attached a few files of what my excel spreadsheet for my survey looks like as well as the exported output excel file. All I want is the correct date and time for the data collected. I'm assuming theres something wrong with my formula or the way it "talks" to the DateTime field.
Any input or guidance would be much appreciated.