Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 08-23-2016, 07:04 AM
JulieS JulieS is offline how to export the work and duration.... Windows 7 64bit how to export the work and duration.... Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Start with the Budget Work Visual Report


Select Level of usage data = Weeks.
Click View to create the report and export the data to Excel.
Click the Assignment usage tab in the Excel spreadsheet to see the Pivot table
In the Pivot Table field list, click Resources to add Resources to the list.
Drag Tasks from the Filters area into the Rows area after Resources
Right click on one of the tasks and select Show Properties in Report. Select Scheduled Start and Scheduled Finish to show the dates of the task
Drag weekly calendar to Columns
Uncheck Actual work, Baseline Work, and Budget work to see just Work.
Hide columns as needed.

You can also get very close to the Who Does What report by printing the Resource usage view. As needed add the Start and Finish dates to see when the work occurs.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
how to export the work and duration.... Duration & Work Hours Not Close fkistner Project 1 10-31-2015 11:51 AM
how to export the work and duration.... Work vs. Duration Cameronk Project 1 05-14-2015 02:29 PM
how to export the work and duration.... getting hung up on duration vs. work cuseman03 Project 5 05-14-2015 02:19 PM
Work not changing duration benoldays Project 0 02-14-2011 08:21 PM
Duration changes fail to update work effort Panteledes Project 6 05-25-2010 02:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:55 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft