Copy info from Resource Usage View to Excel

J

Jan

Hi,
Hopefully a small problem I encounter. But I have a nice
view in the resource view with all kinds of data I find
useful to play around with in Excel.
But unfortunately everything I copy into Excel includes
the hour symbol (f.i. 20h) and in Excel this is a string.

Is there a way to solve this, f.i. by not seeing the hour
symbol in the Resource Usage View?

tia,

Jan van Eyck
 
J

John

Jan,
It sounds like you are doing a direct copy and paste and that is why you
are getting the "h". A much better approach is to use the built in
function, "Analyze timescale data in Excel". That can be found on the
"analysis" toolbar. If it is not available, you can download it from the
Microsoft Project website.

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Resource Usage View Rolled Up 4
Resource Usage View 2
BCWS Incorrect in Resource Usage View 1
Resource Usage Rollup 2
changing the scale from hours to days in the Resource Usage view 1
Exporting Project to Excel - Resource Usage Question 0
Exporting data from Resource Usage View to Excel 1
Export resource information 2

Top