B
Bill
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
5/24/2004 11:45
5/11/2004 11:40
5/18/2004 14:05
5/15/2004 11:45
5/24/2004 13:48
5/14/2004 17:03
5/11/2004 16:26
5/24/2004 14:51
5/3/2004 16:24
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
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
5/24/2004 11:45
5/11/2004 11:40
5/18/2004 14:05
5/15/2004 11:45
5/24/2004 13:48
5/14/2004 17:03
5/11/2004 16:26
5/24/2004 14:51
5/3/2004 16:24
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