Thread: Seperate date and time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default 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



Reply With QuoteReply With Quote