ExcelBanter - military format of time

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - military format of time (https://www.excelbanter.com/excel-discussion-misc-queries/188148-military-format-time.html)

awais

military format of time

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.

Roger Govier[_3_]

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.

All times are GMT +1. The time now is 11:12 PM.