I have a user form that I input data and would like to input military time so I do not need to use the ":" . The data gets added to an excel spreadsheet. I have tried numerous other suggestions and codes that I have found online, but nothing seems to work right. Please help me out, this is really frustrating me.

- - - - - - - - - - - -- - -- - - -
Code I am using is here:

With Me
c.Value = .TextBox6.Value
c.**fset(0, 1).Value = .TextBox1.Value
c.**fset(0, 2).Value = .TextBox3.Value
c.**fset(0, 3).Value = .TextBox4.Value
c.**fset(0, 4).Value = CDate(txtshift)
c.**fset(0, 5).Value = .TextBox2.Value
c.**fset(0, 6).Value = CDate(txtshift)
c.**fset(0, 13).Value = .TextBox17.Value
ClearControls
End With
Application.ScreenUpdating = True
End Sub

_______________________________
Private Sub TextBox18_CDate(txtshift)
TextBox18.Value = Format(.Value, "hh:mm")
End Sub
________________

Private Sub TextBox19_CDate(txtshift)
TextBox19.Value = Format(.Value, "hhmm")
End Sub
- - - - - - - - - - - - - - - -
Displays on Excel: (the time section that is not working)
Qty Start time Breaks Stop time
400 00:00 30 00:00
600 00:00 30 00:00
200 00:00 15 00:00

Thank you in advance.
Dave