i-nth logo
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.

Full article: 3 ways to group times in Excel