Data Uploader Not Displaying Time from Import

Katye Reed
Katye Reed ✭✭✭✭✭
edited 06/14/22 in Add Ons and Integrations

Hello,

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.

When

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.

Tags:

Answers