export data from Ms. Project to excel adds "h" or "d" string 1

[MartinFI]

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?

 

[IRstuff]

If you get rid of the "h" and "d", how are you going to tell the difference between 80 days and 80 hours?

TTFN

 

[MartinFI]

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.

 

[IRstuff]

You didn't answer my question.

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.

TTFN

 

[WillRussell]

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!