Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an Excel file: payroll.xlsx

I need to do the following, but I'm not sure how:

Create a pivot table that computes per employee how many times s/he checked in and her/his average amount of time worked. There should be a block of rows in the table for each employee for whom you have payroll data, and each block should have separate entries for the number of shifts worked and the average time worked by that employee.

I'm not sure if the Excel file is just wrong or if I'm not doing it correctly. It's supposed to have: Employee Names (not Employee ID).

share|improve this question

migrated from Apr 19 '11 at 4:42

This question came from our site for professional and enthusiast programmers.

You need to add a column 'Employee Name' to the source table in column G. Do this with the following formula:


Refresh your pivot table and use 'Employee Name' instead of 'Employee ID'.

share|improve this answer

You must log in to answer this question.