Converting Datetime from Excel applies incorrect date

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 ...