## 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.