=--SUBSTITUTE(SUBSTITUTE(A1,"AM"," AM"),"PM"," PM")


"Steve Vincent" wrote:

I need to convert a time that I import as text into military time. The time
format is hh:mm:ssPM/AM (in other words, the times in text appear as
01:25:23AM , 02:34:11PM , 11:54:01AM , 03:51:13PM , etc. ).

When I try to use TIMEVALUE, I get the #VALUE! error. It appears that the
argument for TIMEVALUE must be in quotes. I have tried a number of methods
to get TIMEVALUE to recognize the text time, but it never works (I have tried
concatenating quote marks with the cell reference, etc.).

This should be easy (one would think!) -- how can I convert this fairly
straightforward text time into military time? I have searched this forum and
have not found this specific issue addressed. Thanks in advance for any help
you can offer.

Steve