How to change date time with actual time to date time with all time as 12 am in power query.

[user35131]

For mathematical purposes I want to keep the date time format. For example I have a row that looks like this 12/23/2020 12:04:56 and I want it to be 12/23/2020 12:00:00. 

Same goes for a row that looks like this 04/15/2023 04:45:34 into 04/15/2023 12:00:00. 

[parry2k]

@user35131 add a new column PQ as below, and then change the type of this columns to datetime

Date.From([DateTime Column])