Data Uploader Not Displaying Time from Import
I am using Data uploader to import data from an excel sheet. It is critical that we pull in the date and time from the sheet. However, the time is not being pulled in - only the date. So i went to the source excel sheet and extracted the into a separate column. I used the =TIME(HOUR(G2),MINUTE(G2),SECOND(G2)) and changed the format of the cell to display as a time.
the data is imported it messes up the time, see screen shot attached. Any advice on how to resolve or at least a workaround to pull in the timestamp.