A--------------------------B-------------------C
OLD DATA NewDate NewTime
8/19/2008 16:00 PDT 8/19/08 16:00
12/30/2008 0:00 PST 12/30/08 #VALUE!
12/31/2008 3:15 PST 12/31/08 #VALUE!
12/29/2008 23:15 PST 12/29/08 #VALUE!
12/30/2008 8:30 PST 12/30/08 #VALUE!

NewDate formula=VALUE(LEFT($A2,FIND(" ",$A2,1)))
NewTime formula=VALUE(MID($A2,(FIND(" ",$A2,1))+1,FIND(" ",$A2,1)-4))

Can someone help me with a formula that will return split up (column A
--date/time) into two columns where the date is in column B and the time is
in column C. The formula I am using is returning a value error for the time.

Thank you for your help