Author: Oscar Cronquist Article last updated on October 25, 2019

Today I am going to demonstrate how amazing pivot tables are! Take a look at this time sheet.

You can expand each month and see time spend on each project. The pivot table also shows a summary of both months and projects.

I made the pivot table from a simple table containing fake project time data.

This table can have duplicate dates, as you may be working on multiple projects in a single day.

How I created the Pivot Table

  1. Select a cell in your table.
  2. Go to tab "Insert".
  3. Press with left mouse button on "Pivot table" button.
  4. Press with left mouse button on OK.

Arrange data

  1. Press with left mouse button on and drag "Day" from "Pivot table Field List" to "Column Labels" area.
  2. Resize pivot table columns widths.
  3. Press with left mouse button on and drag "Date" to "Row Labels" area.
  4. Press with right mouse button on on a date and select "Group".
  5. Select months and press with left mouse button on OK.
  6. Press with left mouse button on and drag "Project" to "Row Labels" area.
  7. Press with left mouse button on and drag "Regular hours" to "Values" area.
  8. Go to tab "Design".
  9. Press with left mouse button on "Subtotals" button.
  10. Press with left mouse button on "Show all subtotals at bottom of group".
  11. Press with left mouse button on and drag overtime hours to "Values" area.
  12. Change headers "Sum of Regular hours" to R and "Sum of overtime hours" to O.

Picture of a monthly timesheet by project with overtime hours.

Recommended articles