time

C

chartasap

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

Jonathan Cooper

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

[$-409]h:mm AM/PM;@
 
B

Bob Phillips

=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)
 
Top