Seperate date and time
 

Using Excel 2007 is their a way to seperate this format in one cell:
6/24/2009 12:01:32 PM to two cells with the date in one and the time beside
it in another cell: (cell A) 6/24/2009; (cell B) 12:01:32 PM

Seperate date and time
 

=INT(A1)
format cell as Date

=MOD(A1,1)
format cell as Time


"RD" wrote:

Using Excel 2007 is their a way to seperate this format in one cell:
6/24/2009 12:01:32 PM to two cells with the date in one and the time beside
it in another cell: (cell A) 6/24/2009; (cell B) 12:01:32 PM

Seperate date and time
 

Hi,

1. Highlight all the date/time enteries and choose Data, Text to Columns,
Fixed Width, click Next. In the Data preview area leave one line (arrow)
directly to the right of the longest dates, and remove any other lines.
Click Next, choose a Destination cell and click Finish.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"RD" wrote:

Using Excel 2007 is their a way to seperate this format in one cell:
6/24/2009 12:01:32 PM to two cells with the date in one and the time beside
it in another cell: (cell A) 6/24/2009; (cell B) 12:01:32 PM

Seperate date and time
 

Yes. Thanks.

"Shane Devenshire" wrote in
message ...
Hi,

1. Highlight all the date/time enteries and choose Data, Text to Columns,
Fixed Width, click Next. In the Data preview area leave one line (arrow)
directly to the right of the longest dates, and remove any other lines.
Click Next, choose a Destination cell and click Finish.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"RD" wrote:

Using Excel 2007 is their a way to seperate this format in one cell:
6/24/2009 12:01:32 PM to two cells with the date in one and the time
beside
it in another cell: (cell A) 6/24/2009; (cell B) 12:01:32 PM

Seperate date and time
 

This works but Shane devonshire's below did the best for my situation.
Thanks.

"Teethless mama" wrote in message
...
=INT(A1)
format cell as Date

=MOD(A1,1)
format cell as Time


"RD" wrote:

Using Excel 2007 is their a way to seperate this format in one cell:
6/24/2009 12:01:32 PM to two cells with the date in one and the time
beside
it in another cell: (cell A) 6/24/2009; (cell B) 12:01:32 PM