ExcelBanter - formating military time

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - formating military time (https://www.excelbanter.com/excel-programming/332797-formating-military-time.html)

LHaro

formating military time

Hello,

I am trying to format military time in excel to display regular times
(without displaying the AM/PM). For Example, I have a cell that contains
1:00:00 PM, it is displayed as 13:00, but i want it to display 1:00. Any
help on this would be greatly appreciated.

Many Thanks

All times are GMT +1. The time now is 04:01 PM.