Thanks for all of the help.....I got what I need. Thanks again.
--
JT


"Teethless mama" wrote:

=A1*1

format cell as hh:mm AM/PM

"JT" wrote:

I have a spreadsheet with time displayed as 19:46. This is a text string and
I would like to convert it to 7:46 PM.

Is there a formula that will convert these text strings to time?

Thanks for the help......
--
JT