View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tiptop[_8_] tiptop[_8_] is offline
external usenet poster
 
Posts: 1
Default Converting Time in a userform

Quick Question, I have a userform, that in Textbox1 someone will ente
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 conver
Textbox2.text = 22:04.

Any ideas

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