Extract time and date from Text

I have rows of date and time in text format and it looks like this - May 13, 2012 9:10 AM
(pls note that the time could also be 4 digits, eg: 12:11 PM)

Looking for help for formulas

1) To extract the date in another row in DD-MM-YYYY format
2) To extract the time in another row in 24 hours clock format, eg: 15:14, 09:15


Btw, I have also asked the same question in another forum, but couldn't get the answer, thus this repost in this forum)
Pls see the orginal post here - http://www.mrexcel.com/forum/excel-q...date-text.html
Thanks much!

It is a cross post
Please add link of your thread in the form you have posted earlier
Thanks

Try these two

For date

=--LEFT(A1,12)

Format Custom: DD-MM-YYYY

For time

=--TRIM(RIGHT(A1,8))

Format Custom: [h]:mm

These formulas will convert text date/time to real values however, if you simply want to separate date and time and leave them as text use formulas below:

=TEXT(A1,"dd-mm-yyyy")

=TEXT(A1,"h:mm")

	A	B	C
1	May 13, 2012 9:10 AM	13-05-2012	9:10

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

Please see attached file.

Please find the attached File