×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

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

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

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

(OP)
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?

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

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

TTFN

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

(OP)
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.

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

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

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

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!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources