View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal[_2_] Robert Crandal[_2_] is offline
external usenet poster
 
Posts: 158
Default Convert time to military time?

How can I convert the current time into military time?
I'd like to show the results in a message box kind of
like:

MsgBox "The military time is: " & strMilitaryTime

The variable strMilitaryTime is a string variable which
is where I want to store the current military time. Oh
ya, I want the military time format to be: "hh:mm:ss",
so 3:42:11 PM should convert to 15:42:11, etc...

Thank you!

Robert Crandal.