Date Format

[#1]

Hi,

I want to load this sample file. But date formats are different. For some of the rows it is in 24 HR format and some rows in AM and PM format. Please find attached sample data. I need Month, Date and Hour format.

Thanks

[#2]

Thank You all