I have a bunch of logs that I need to combine, each is a excel file with no tables and a bunch of timestamps. The timestamps are datetime in excel, the datevalue includes the date.
When I try to convert the column to datetime from text, the time is correct but the date is not.
It's showing as 12 April instead of 4 April.
Is there a way I can get it to reflect the datetime as per the Excel cell value?
These reports are in .xls format.