4 Replies Latest reply: Jun 19, 2013 5:16 AM by Dike van Beijnen RSS

    How to calculate average hours per week

      All worked hours are registered in our database. Hours are registered per week and per project.

      I have created a pivot table that shows worked hours per week, and the total of worked hours for each project. So far so good.

      Now I want to add an extra column that shows the average number of hours worked per week for each project.

      The average should be taken of the total number of weeks registered (so regardless of the project!) If no hours were registered in a week than this week should not be used in the calculation.

      See the Excel example for clarification.

      Hope someone can help!