Create a Scheduled Hours Report

Applies to

10,000ft

Reports won't show you scheduled hours per person within a project. However, you can export the data you need create a pivot table to display this information.

To Create a Scheduled Hours Pivot Table:

  1. On the left menu of the Project Page click Time & Fees report.
  2. In the top right corner of the Time & Fees report, click Export and then click Export Underlying Data as CSV.
  3. Open the CSV in Excel. On the Insert menu, click Pivot Table.  Accept the default values in the pop-up and click OK
  4. In the PivotTable Field List, check Project and Team Member and make they appear under Row Labels. Then check Scheduled (hours) and make sure it appears under Values

The table now shows the number of hours each person was scheduled for this project.

scheduled hours report