The staging log records arrivals relative to doors opening. A negative value means the arrival was early. To group the log, name each five-minute interval by the boundary at its start.

Enter -11 in B2 and 11 in B3 as numeric minute offsets. In C2, use =FLOOR.MATH(B2,5) and fill down. Expect -15 and 10. With its default handling of negative numbers, FLOOR.MATH sends -11 to the lower multiple of five.

The time axis maps −11 to −15 and 11 to 10.

Example signed offsets. The output is the earlier boundary, in minutes.

Check an exact boundary

Try -10. It stays -10 because it starts a new bucket. In this setup, the bucket called -15 covers offsets from -15 inclusive up to -10 exclusive. If the source stores spreadsheet time fractions instead of minute counts, convert to minutes before applying this example.

An interval from −15 inclusive to −10 exclusive shows −10 starting the next bucket.

Example boundary check. An exact multiple of five stays at that boundary.

Label the helper “Bucket start (minutes)” so the reader can distinguish the interval label from the recorded arrival time.

Microsoft’s FLOOR.MATH function reference.