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;@



"chartasap" wrote:

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!!

=TIMEVALUE(LEFT(A1,FIND(" ",A1)-1))

and formt the cell as h:mm AM/PM

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"chartasap" wrote in message
...
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!!