Entering 24hr time values

CHarrison1968 You can do this with a bit of VBA code. RIght-click the sheet tab and choose View Code. Paste in this code:

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim val As Variant
    If Intersect(Target, Range("A:A")) Is Nothing Then Exit Sub 'Only do this for column A
    If Target.Cells.Count = 1 Then
        val = Target.Text
        If InStr(val, ":") > 0 Then Exit Sub 'Already has colon
        val = Format(val, "0000")
        val = Left(val, 2) & ":" & Right(val, 2)
        Application.EnableEvents = False
        Target.Value = val
        Application.EnableEvents = True
    End If
End Sub