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