Macro not reading data properly from one excel file but has no issues with other.

[Pardeep]

I have built an Alteryx workflow to import data from different excel files and perform some analysis on it. However while importing data, my macro imports times in wrong format just for one excel file but imports correctly for every other file. I have checked the excel file and the data is in same format as other 16 files. Looked every where for a solution but found no answers. Please if anyone can give me any clue on what might I be doing wrong would be of great help.

[gabrielvilella · Accepted solution]

This is related to how Excel is storing the data. You can work around this issue using a formula to remove the date and keep just the time on that field. Like Right([Time], 8)