hi tiptop

i've just done this recently in i actually used three fields - one for hour
one for min & one for am/pm
(i actually put spin buttons & set min & max on the hour & min box too)
*******
If cboAM = "PM" Then
If txthrs = 12 Then
Else
txthrs = txthrs + 12
End If
Else
If txthrs = 12 Then
txthrs = 24
End If
End If

ftime = Format(txthrs, "00") & ":" & Format(txtmins, "00")
Range("A1").Value = ftime

*********

Cheers
JulieD



"tiptop " wrote in message
...
Quick Question, I have a userform, that in Textbox1 someone will enter
a time and I need it to return the time in Military time in TextBox2.
How can I set this up?

Ex.
When someone enters in Textbox1.text = 10:04 pm, I need it to convert
Textbox2.text = 22:04.

Any ideas?


---
Message posted from http://www.ExcelForum.com/