converting date and time fields

  • Thread starter Thread starter neuman
  • Start date Start date
N

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
 
thanks!
Laura Cook said:
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.
Click to expand...
 
Back
Top