Hello-
I am attempting to sort a large amount of data(400k inputs) by time. However the way it is sent to me is with the date and time together in one cell.
ie. DateTime
4/5/2011 9:36
4/5/2011 9:43
4/5/2011 9:52
4/5/2011 10:01
4/5/2011 10:02
4/5/2011 10:06
4/5/2011 10:38
I am looking to sort the data so I see only the data between 10:15 and 3:45....
I am very confused on how to do this. I can not get the date and time broken out into separate columns, which would make this much easier.
Thanks in advance.
Bookmarks