Hello!
I have a file that has the Date and Time combined into one cell. I want to separate the two, and cannot find anywhere on the net to do so!
This is the cells format:
d/mm/yyyy h:mm
Cells look like this:
28/05/2008 12:30
Does anyone know how to separate these with VBA code? changing the cell format changes the look of the cell, but the underlying numbers are still the same. Any ideas?
Cheers
Last edited by ben_patto; 09-24-2009 at 08:48 PM.
So are you looking to override the DateTime with Date and push Time into adjacent cell ?
(in VBA terms you can use .Text and split by space else remember that Dates are Integers and Time is Decimal...)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
I'm heading offline shortly but assuming you want to split such that datetime values in A become date only in A and time only in B then:
Please Login or Register to view this content.
Thank you! works great! does exactly what I wanted!
Cheers
what would the code look like if I wanted to store the two values into an array rather than offsetting them to other cells?
Say shift_time(i) and shift_date(i)?
I keep getting an error message when i change the above code?
Along the lines of:
the transpose is not strictly requiredPlease Login or Register to view this content.
Excellent! Thankyou very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks