Military Time

[katiapro93]

Hello Everyone, I need help again. I have a spreadsheet that has a column with a date and military time which I want to seperate into two columns. When I do that thru delimiting it under the Data tab, the time column looses its military format. I need to keep the military time and I don't see anything under cell format that helps. Any ideas? Example below:

3/29/13 13:23:01 It becomes 3/29/13 and 1:23 p.m. I need it to stay as 13:23:01

 

[Comfy]

The column that the time ends up in must be formatted as h:mm AM/PM change the format of this column to hh:mm:ss

 

[oldbrewer]

format the time column using custom to hh:mm:ss