When I export data from Ms. Project to excel, project adds to duration and work the “h” or “d” string. How can I solve this without use Edit/Replace in Excel?
I need to make a pibot Table, the "h" or "d" makes the data string, but in a pibot table i need numberic data.
That´s the reason beacouse i want to remove those strings.
Since the "h" and "d" are a factor of 8 different, you would need to convert everything into hours or days or whatever, which is something you would have to do in Excel anyway. Only after you convert to a single time unit will it make sense to do what you're talking about.
You could use the macro "Format_duration" to convert all your durations to the same units and then export to excel, surely a "find and replace" doesn't take that long!
