I can't get this code to reformat the time to hh:mm and keep the numbers there. it just clears the number and reformats the field.
Private Sub Worksheet_Change(ByVal Target As Range)
If Selection.Count > 1 Then
Exit Sub
End If
If Not Intersect(Range("C3:N33"), Target) Is Nothing Then...