Thread: military format of time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
  
Posts: 2,480
Default military format of time
Hi
take a look at Chip Pearson's site
http://www.cpearson.com/Excel/DateTimeEntry.htm

--
Regards
Roger Govier

"awais" wrote in message
...
how can i feed time in military format? e.g. 1210 for 12:10 PM, 1740 for
17:40 PM, 0030 for 12:30 AM.

Reply With QuoteReply With Quote