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.

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.

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.



