I have a series of dates in this format: 20100818133346
That I need to conver to: 08/18/2010 1:33:46 PM
I have a standard working knowledge of Excel, but no experience in writing formulas for this type of conversion. Any help would be greatly appreciated.
Thanks,
Bob Siebecker
The date is always in 8 digits?
Or there are dates with less digits?
The time is Always in 6 digits?
Or there are times with less digits?
Date and time in same cell?
Date and time in differant cells?
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Try
=TEXT(LEFT(A1,8),"0000\/00\/00")+TEXT(RIGHT(A1,6),"00\:00\:00")
And custom format the cell with the formula as mm/dd/yyyy h:mm:ss AM/PM
Excellent. Thanks so much Jonmo1!
You're welcome..
After a little more thought, considering this has worked for you.
It can be shortened a bit
=TEXT(A1,"0000\/00\/00 00\:00\:00")+0
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks