Right click on the cells that you want to convert, then go to format cells.
In the category list of the number tab, you will have the choice of the time
settings that you can choose from (Under "Time" in the list)

Hope this helps.

Martin






"telewats" wrote:


I am attempting to convert already existing data to military time. The
existing data is dumped in from another program, and it currently looks
like 5:58:08 a.m. and 3:01:29 p.m. I want them to show up 5:58:08
and 13:01:29 (without the a.m. and p.m.)
Users are currently using the "replace all" option to convert these,
but it's a four-step process, and I keep thinking there has got to be
an easier way! Can someone help?


--
telewats
------------------------------------------------------------------------
telewats's Profile: http://www.excelforum.com/member.php...o&userid=30270
View this thread: http://www.excelforum.com/showthread...hreadid=521817