converting military time
Yes....I am sure it is displayed as text because when I use Format
Cell.Text is already highlighted.
--
JT
"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
|