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?
Bookmarks