Thread: splitting and formating a number series into date/time
View Single Post
  #5  
Old August 29th, 2008, 01:27 AM posted to microsoft.public.excel.worksheet.functions
David Biddulph
external usenet poster
  
Posts: 8,714
Default splitting and formating a number series into date/time
=INT(TEXT(A2,"0000\-00\-00 00\:00\:00"))
=MOD(TEXT(A2,"0000\-00\-00 00\:00\:00"),1)

Format as date & time respectively.
--
David Biddulph

"CMG8401" wrote in message
...
I have a data series that looks like:
20080127145747 (YearMonthDayHoursMinutesSeconds)

I need to break that up into two columns
Date (Month/Day/Year) and Time (Hours:Minutes:Seconds)

Please help