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