Hi,
Actually I am expecting a automation regarding formatting of my data N69:Q111,it should be in the format as stated above of N69.Since below it has rough data which I have to do manually since this is time consuming and like this I have a lot of data.
Can anyone help in this sort of case.
With Best Rgds,
Suresh
Your data is not showing up like the rest because it is text, not date/time (numeric)
Try this, to convert it, use 4 helper columns with this, copied down and across...
=DATE(2014,MID(N69,4,2),LEFT(N69,2))+TIME(MID(N69,7,FIND(".",N69,1)-FIND(" ",N69,1)-1),MID(N69,FIND(".",N69,1)+1,2),0)
Then, copy/paste values over the original date, and delete the helpers...then format as above
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Dear Sir,
Thanks for the reply.I did with helper column but there is one problem that is of AM & PM case.The raw data does not contain AM & PM.Also,there is date change also problem.And this is possible while doing manually by looking into the pattern of each row.
I have used your formula in 4 helper column at S69:V111 where in few rows I have highlited with yellow which should be PM and green highlighted date change must be there i.e here in V72 it should change to 8/10 05:00 AM after looking into pattern and also, I have done all manually at 'Expected solution' which is mentioned at X69:AA111 which also my desired solution.
Hope you understand so that you can futher improvise the existing formula.Workbook is enclosed for your kind reference.
With Best Rgds,
Suresh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks