3 ways to group times in Excel

In this article we are going to learn a few different ways to summarize data based on time groups (increments of hours or minutes):

• Solution #1 – Group time with a Pivot Table.
• Solution #2 – The FLOOR function.
• Solution #3 – The VLOOKUP function.

The quickest and easiest method is probably to use the Group feature in a Pivot Table. If you want to group the times in increments of multiple hours or fractions of an hour, then the FLOOR and VLOOKUP functions can help group the times.