converting military time

G

Guest

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......
 
G

Guest

Are you sure it's formatted as text? When I enter 19:46 in a cell and format
as text it displays as .823611 (i.e., 82.3% of a 24-hour day).

Have you tried formatting the cell as AM/PM?
 
G

Guest

Yes....I am sure it is displayed as text because when I use Format >
Cell.Text is already highlighted.
 
P

Paris

Ï/Ç JT Ýãñáøå:
I have a spreadsheet with time displayed as 19:46. This is a text stringand
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......

FORMULA -> =TIMEVALUE(***YOUR CELL WITH TEXT HERE***)

AND FORMAT CELL -> TIME -> 7:46 PM
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top