solve Another Question

Okay, I've been able to surpass one obstacle, thanks to this board. Now I have another question. Now that I have two columns, one containing the date and one the time, how can I put them into order. I've tried the sort function, but the times are not moving accordingly. If I select everything, the dates move accordingly, but the times are then not in their appopriate place. Here is a small example of what my chart looks like:

1/15/2007 01:08:57PM
1/15/2007 02:37:54PM
1/15/2007 02:42:59PM
1/15/2007 07:42:22AM
1/15/2007 07:47:03AM
1/15/2007 10:02:39AM
1/15/2007 10:02:39AM

As you can see, the date is fine, but I need the times to be in order. Right now it recognizes 1:08pm to be the earliest in the day. How can I adjust? I hope I'm clear. Thank you.