How to parse date/time stamp into different fields?

I have a file that needs analysis that has a date/time stamp in one column like:

02/01/2008 9:04:23AM

I would like to split this into two separate columns, so I can perform individual functions on just the date or just the time by themselves...

Any suggestions?

Thanks!
Chris

Hi, If dates in column "A" the results in "A" and "C"

Please Login or Register  to view this content.

Mick