This free Excel macro formats a selection of cells in the Time format in Excel. This Time number format means that instead of just numbers, an actual sort of digital clock display will appear. By default, this format is in hh:mm:ss AM/PM. This means the Time format will show the hour, the minute, the seconds, and the AM or PM designation in Excel.
If you are working with time in Excel, you need to use the Time number format. This macro allows you to quickly and easily apply this format to a large number of cells in Excel.
Sub Format_Cell_Time()
Selection.NumberFormat = "[$-F400]h:mm:ss AM/PM"
End Sub