How to separate date and time into different cells

I have date and time in column A in the following format:
31-Dec-2012 06:23:00 PM PST

I'd like to separate date into one column and time into another. I tried the formula =INT(A1) but I get a #VALUE error.
Can someone help please?

I'm trying to calculate average daily transactions. Thus, once I format column A into date only, I could do a COUNT formula to calculate how many transactions took place on each day. Unless one of you has a better method.

Your dates are in text format, so you need to manipulate them a bit further. For the dates, try this:

=VALUE(LEFT(A1,11))

and for the times you can use this:

=MID(A1,13,8)+IF(MID(A1,22,2)="PM",0.5,0)

Format the cells appropriately.

Hope this helps.

Pete

Thanks, Pete!
This is great, but I think I'm getting rusty. I didn't need the time stamp to sort daily transactions. So I just did a Find and Replce using "space*" and replace with blank. That got rid of the time stamps and left me with only the date info that I needed. But I'll keep your solution in mind for future reference!

Well, you title asked about separating dates and times, but glad to hear you reached a solution on your own.

Pete