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