The Resource Work Availability Visual Report can give you that information. All of the visual reports take data from Project and create Pivot tables in Excel.
Run the Resource Work Availability report and then do the following:
On the Resource Usage tab in Excel, click in to the Pivot table to show the Pivot Table field list.
In the list, select Resources to show the resource names.
Drag the calendar to Columns.
The default report shows Work Availability, Work, and Remaining Availability.
|