Converting text string to a its proper time format
Try a formula of
=TIME(LEFT(A1,FIND(":",A1)-1),MID(A1,FIND(":",A1)+1,2),0)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Edmund Wong" wrote in message
...
I have series of times in a column that is formatted as 9:30a, 9:40a,
etc. How do I convert these to time, i.e., 9:30 AM, etc.?
thanks
|