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