converting date and time fields

[neuman]

Hello,
I have columns that contain date and time in the "14/07/2003 17:57:00"
format.
I need to convert them into date-only and time-only fields (not only
visually).
How do I get rid of the date/time part?
Thanks

 

[neuman]

thanks!

With date and time in column A, in B1 enter:

=INT(A1)

Format as a date. Now in C1 enter:

=A1-B1

Format as a time.

Copy the formulas down as far as needed. If you no longer need column A,
select both column B & C and Copy, then Paste > Special > Values. Now you
can delete column A.