3 ways to group times in Excel

3 ways to group times in Excel

18 October 2015

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.