How do I split the date & time into two separate columns?

xladept, I tried general formatting. It doesn't do anything. It's already in the correct format of "hh:mm:ss." Even when I try to format it in military time, it still reads it as 12:00:10 instead of 00:00:10.