Character to DateTime Conversion Help Needed

[#1]

Hi 

I am attaching a sample single row table. 

Date1 column is character 

e.g. 03-Mar-22 12.13 PM

ie. DD-MMM-YY HH.MM am/pm

Date2 has a datetime format

I need a formula for especially Date1 to convert it into DateTime w/ desired format of 

MM/DD/YYYY HH:MM:SS am/pm

(SS, seconds would be automatically zero )

My goal is to update a table based on a second one (or join) once I can 2 comparable datetime columns 

note: I tried some attempts, none worked so far. Appreciate the help. 

thanks

[#2]

Brady, 

It's been long time and I hope you are doing well. 

Your technical solution certainly does well, as it did work great. In the end, it was so simple.

thanks again for your support.