Part IV: Managing and Analyzing Data
Grouping by time
Figure 30.10 shows a set of data in columns A:B. Each row is a reading from a measurement
instrument, taken at one-minute intervals throughout an entire day. The table has 1,440
rows, each representing one minute. The PivotTable (in columns D:G) summarizes the data
by hour.
FIGURE 30.10
This PivotTable is grouped by hours.
This workbook, named time-based grouping.xlsx, is available on this book’s website at www
.wiley.com/go/excel2019bible.
Here are the settings to use for this PivotTable:
■ The Values area has three instances of the Reading field, and each instance displays
a different summary method (Average, Minimum, and Maximum). To change the
