Do you know how I can convert a column with 01/02/2004 9:14:12 AM to a time (09:14:12) thx..
T thdorsky2 Mar 4, 2005 #1 Do you know how I can convert a column with 01/02/2004 9:14:12 AM to a time (09:14:12) thx..
P Peo Sjoblom Mar 4, 2005 #2 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
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
