I'm trying to figure out how the time generated in DatePicker is stored into excel online. If the app is refreshed it loggs the date and time as such:
however, if the app isnt refreshed but a new record is submitted then the data is logged as such:
How could this be possible? Honestly the defualt time being logged is fine however, I need to know how to change it so that my formulas in excel will work. Instead of 10/29/2018 5:00 I would need it to say 10/29/2018 12:00. I am completely new to the power apps community and i've spent the better part of a week trying to solve this problem on my own. I appreciate any help that can be provided.