To create the PivotTable, click somewhere in the list of data, choose the Insert tab, and click PivotTable. Excel will automatically select the area containing the data, including the headings.

A PivotTable is an easy way to display the first and last time from a timestamp in Excel. If a PivotTable is acceptable reporting, it’s the easiest solution.

This is the demonstration file to accompany the article, How to display multiple grand total rows in a Microsoft Excel PivotTable by Susan Harkins.