Explanation

If you better group times into buckets (i.e.

group by 6 hours, group by 3 hours, etc.)

you might do so with a rounding function called FLOOR.

Excel formula: Group times into unequal buckets

In the example shown, we have a number of transactions, each with a timestamp.

A time of 8:45 AM needs to go into the 6:00 AM-9:00 AM bucket, and so on.

FLOOR works like the MROUND function, but FLOORalways rounds down.

Excel formula: Extract time from a date and time

Excel formula: Round time to nearest 15 minutes

Excel formula: Random times at specific intervals

Excel FLOOR function