Hello to all
My issue is relate to a database query application that export the data in a format that I had been unable to use to generate graphs or pivot table or graphs. It a turnaround query and looks like is exported as d hh:mm but when exporte to excel I can't custom the format or delete the nitial 3 character with formulas as : =RIGHT(Xx,LEN(Xx)-3) because them I can't use the result cell in graphs or pivots.
I'll like to know if there is another formula or macro that can help me to convert those columns in a excel valid format.
I'm attaching a screenshot with an example of the problem where the top table represent the original data afetr exported from the application and the botton table is how I'll like to see in order to generate pivot or graph.
Thanks fro any help...
Felipe
7t4d.jpg
http://img153.imageshack.us/img153/6955/7t4d.jpg
Bookmarks