Removing the h from Task Usage View Work

[Billy]

I would like to copy and paste date from the task usage view. How do
you turn off the "h" representing hours of work? I want to copy and
paste numbers, not text.

 

[John]

I would like to copy and paste date from the task usage view. How do
you turn off the "h" representing hours of work? I want to copy and
paste numbers, not text.

Billy,
Sorry, you will need to remove the "h" once the data is in the other
application. You can do that either manually or write a simple macro to
do so.

John
Project MVP

 

[Dave]

Use another number field and export that instead.

Apply the formula:

[Number1]=[Work]/60

The division by 60 is to convert the work from minutes to hours. You
may want to make sure that the rollup to summary line options are set to
your liking before exporting.

 

[Rod Gill]

In Excel I just do a search and replace of h for nothing and that works fine

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[Billy]

Thanks for all the ideas. I'll use one of them.

In Excel I just do a search and replace of h for nothing and that works fine

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

---------------------------------------------------------------------------­-------------------------

 

[John]

Thanks for all the ideas. I'll use one of them.

Billy,
You're welcome and thanks for the feedback.
John