Bill,

I don't know if will suit your purposes, but it looks like what you want...
Make two identical columns
Format the first column as a date - mm/dd/yyyy
Format the second column as time - h:mm:ss AM/PM

Regards,
Jim Cone
San Francisco, CA

"Bill" wrote in message om...
I have a column (well several) that has date and time information in
it, such as what is below:
5/24/2004 14:20
5/12/2004 10:22
5/4/2004 13:54
5/11/2004 16:37
5/24/2004 10:09
5/15/2004 12:05
5/3/2004 12:37
- snip -
I would like to split this column and have the date information in one
column and the time information/data in a different field. In past
cases I have used the =Mid Function but since this is formatted
differently it will not work. When I do the mid function is get
numbers but cannot format them in a date or time that can be read.
This one workbook has around 4000 rows.
I have never written a Macro in Excel so I am totally lost on this one
and I am hoping someone with the skills and knowledge can assist me.
Thanks,
Bill