how do I convert a date and time column to a time column
 

Do you know how I can convert a column with 01/02/2004 9:14:12 AM to a time
(09:14:12)

thx..

Just use a format like hh:mm or hh:mm AM/PM assuming it is real numeric
date/time
if text you can use a help formula

=--MID(A1,FIND(":",A1)-2,32)

copy down/across and format as hh:mm or hh:mm AM/PM


--

Regards,

Peo Sjoblom



"thdorsky2" wrote in message
...
Do you know how I can convert a column with 01/02/2004 9:14:12 AM to a
time
(09:14:12)

thx..