software

if i have the time displayed as follows 13:00 PM and want it to be converted
to 1:00 PM, how would i do this?

Thank you!!

If the cell contains a VALUE rather than text, just change the cell format to

[$-409]h:mm AM/PM;@
quot;chartasapquot; wrote:

gt; if i have the time displayed as follows 13:00 PM and want it to be converted
gt; to 1:00 PM, how would i do this?
gt;
gt; Thank you!!

=TIMEVALUE(LEFT(A1,FIND(quot; quot;,A1)-1))

and formt the cell as h:mm AM/PM

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;chartasapquot; gt; wrote in message
...
gt; if i have the time displayed as follows 13:00 PM and want it to be
converted
gt; to 1:00 PM, how would i do this?
gt;
gt; Thank you!!