4 Replies Latest reply on Apr 16, 2018 4:26 PM by Deepak Rai

    Calculate average hours per person per week

    Michael Zabritski

      This seems like it should be easy but I'm struggling.   I have a data set with hours listed monthly for each employee.  I've calculated the number of days and weeks in each month for each row. I'm now trying to calculate the average hours per person per week.   I'm looking for a single number result that displays a total average per person per week (highlighted in red below).

      Sample Hour Data.jpg

      I've attached a workbook with this data.

       

      Thanks

      Michael