viewing actual work in a specific date range

[Eric H]

how do you generate a view or report that shows actual work for a specific
date range? filtering tasks doesn't reflect the actual work done in that date
range tasks were filtered for.

 

[Rod Gill]

Select View, Resource Usage or Task Usage
Edit the time scale

For actual work:
Select Format, Details, Actual Work (or right mouse click the yellow area)

 

[John]

how do you generate a view or report that shows actual work for a specific
date range? filtering tasks doesn't reflect the actual work done in that date
range tasks were filtered for.

Eric,
Off hand I can't think of any easy way to get the information you want
but there are a couple methods you might try. First, use the "analyze
timescale data in Excel" utility to export Actual Work from the Task
Usage view from Project Start up through the latest date of interest.
Once the data is in Excel formulas can be applied to segregate out the
cumulative Actual Work within the data range of interest.

A slightly more elegant way does not require the use of Excel but does
require the use use of VBA. With a macro, the desired data can be
extracted and placed into a spare field for each task and/or the project
as a whole. A view that includes the spare field then can be printed or
distributed electronically. Actually the VBA code for this isn't very
complex. If you have a little experience with VBA, give it a try. Or if
you need some help, re-post and we can get you started.

Hope this helps.
John
Project MVP