Hi,

I data in a column with the date and time like this:
1/3/2006 7:30:00 AM

I need to have the date in one column and the time in the next.

Thanks!!

With data in Column A,
In B1 enter
=A1
and copy down as needed,
Then, custom format Column A to perhaps
mm/dd/yyyy
AND
Custom format Column B to perhaps
hh:mm AM/PM
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Dan B" wrote in message
...
Hi,

I data in a column with the date and time like this:
1/3/2006 7:30:00 AM

I need to have the date in one column and the time in the next.

Thanks!!

This makes it look the way I want but I actually need them separated for
sorting purposes. Is there a formula that will do it. I tried to use
=right(a1,10) but it just have some numbers that didn't mean anything and
could not be formatted as time.
Any other ideas?

Thanks.


"RagDyeR" wrote in message
...
With data in Column A,
In B1 enter
=A1
and copy down as needed,
Then, custom format Column A to perhaps
mm/dd/yyyy
AND
Custom format Column B to perhaps
hh:mm AM/PM
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Dan B" wrote in message
...
Hi,

I data in a column with the date and time like this:
1/3/2006 7:30:00 AM

I need to have the date in one column and the time in the next.

Thanks!!

Dan B wrote:
This makes it look the way I want but I actually need them separated for
sorting purposes. Is there a formula that will do it. I tried to use
=right(a1,10) but it just have some numbers that didn't mean anything and
could not be formatted as time.
Any other ideas?


Hi Dan B

Try this:

Select the cells containing the data.

Click Data Text to Columns.

Click Delimited, click Next

Uncheck Tab, check Space, click Finish.

Regards

Steve

That did it. I never realized that feature was there.

Thanks!!


"Scoops" wrote in message
oups.com...

Dan B wrote:
This makes it look the way I want but I actually need them separated for
sorting purposes. Is there a formula that will do it. I tried to use
=right(a1,10) but it just have some numbers that didn't mean anything and
could not be formatted as time.
Any other ideas?


Hi Dan B

Try this:

Select the cells containing the data.

Click Data Text to Columns.

Click Delimited, click Next

Uncheck Tab, check Space, click Finish.

Regards

Steve