What about this:
=DATEVALUE(MID(A1,5,3)&" "&MID(A1,9,2)&", "&RIGHT(A1,4))+TIME(MID(A1,12,2),MID(A1,15,2),MID(A1,18,2))
Ensure that all entries follow the same format. All variables are on the same spot, that the month and day is always 3 and 2 char respectively; even if is September 6, it will be Sep 06, etc.
Welcome by the way. Take some time to read the rules. Your post's tittle should describe your problem and not the desired solution
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks