Hi all,

I am sure there is an easy answer to this question, but so far, I have
not been able to find it. I have a cell in this format: 11/18/2007
14:33. I need to separate the time from the date to use in a pivot
table. Is there an easy way to do this? Your help is very much
appreciated.