
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.