Converting Datetime from Excel applies incorrect date

[rusgesig]

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.

[rusgesig]

@Vijay_A_Verma  - sorry not sure if I replied correctly.
Here is the column before transformation.

I'm using a workaround by appending the date to the filename via microsoft flow, then I leave start/end times as time with no date, and extract the date from the filename.

I then generate a time series with hours and minutes, join the start time on that, join the date on the calendar and it all comes together nicely.

[Vijay_A_Verma]

Can you post the screenshot of Start Time column of PQ before converting to datetime?