Adjusting Dates as per Production Shift Timings in R

How to Import Excel Date Format '9/27/21 1:07 PM' into SQL Server Datetime Field Using ADO