Convert MMM DD, YYYY HH: MM: SS am in excel

Question

I have a table that contains the loading time of my website. I want to find the peak hour for my site.

However, dates are saved in the following format:

Jun 02, 2014 01:13:08 am
MMM DD, YYYY HH:MM:SS am / pm

How can I convert this to a date that perfectly understands?

Answer 1

To convert pseudo-data to real dates, select them and run:

Sub ConvertDates()
    Dim r As Range
    For Each r In Selection
        r.Value = CDate(r.Text)
    Next r
End Sub