In the PivotTable group (to the far left), click the Options dropdown (under the PivotTable Name box), and choose Options from the dropdown list. In the resulting dialog, click the Data tab.

In this Excel tutorial, I’ll show you how to create a PivotTable that will do almost everything for you when you need to group records by the hour for reporting purposes.

5. In the resulting PivotTable Fields dialog box, check the boxes next to each field name (as pictured below) to populate the PivotTable with employee time data. 6. The PivotTable will automatically ...