| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i convert a date into 3 seperate columns? | Excel Discussion (Misc queries) | |||
| Seperate Date and Time | Excel Discussion (Misc queries) | |||
| creating a date column from seperate data | Excel Worksheet Functions | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
| How do I link info from 2 seperate documents at same time. | New Users to Excel | |||
Hybrid Mode
