I think I just found an easy way to do it!
With Google, I found this page:
http://en.allexperts.com/q/Excel-105...-time-cell.htm
- Create two new columns.
- Copy the combined date/time column into each one.
- Highlight the first copied column. Change the format to Short Date. (Use Format Cells > Date).
- Highlight the second copy. Change the format to Time (Use Format Cells > Date).
I'm using the American time and date formats, but you can choose whatever format you want.