Excel 2007 : order by date and time remove cells with zeros

Hi,

I have a list of dates that include the time. The list of dates includes zeros.

I would like to order the dates including the time and remove the zeros in a new column but different worksheet.

For example,

Sat, Jan 1, 2011, 9:14 AM
Mon, Jan 3, 2011, 12:21 AM
Sun, Jan 2, 2011, 12:03 AM
1/0/1900 12:00:00 AM
Sat, Jan 1 2011, 10:35 AM
1/0/1900 12:00:00 AM
1/0/1900 12:00:00 AM

Would then be sorted without the zeros by date and time:
Sat, Jan 1, 2011, 9:14 AM
Sat, Jan 1 2011, 10:35 AM
Sun, Jan 2, 2011, 12:03 AM
Mon, Jan 3, 2011, 12:21 AM

Thank you in advance for reading and/or responding!

luix