无法在VBA中正确获取时间值

I have two columns in excel that contain both the time and date in the format: yyyy/mm/dd h:mm:ss AM" (or PM) I eventually have to send both the time and date to a method that creates outlook appointments in the calendar. In a for each loop, this is how extract the date and timeI have two columns in excel that contain both t