I posted this question Friday but I don't think that it was very clear.

I have a spreadsheet that has admission times to different floors. Our
floors range from 3-7 and also includes surgery. The time I am wanting to
count is how long it took the patient to get to the floor once they called
for a bed number. There will be over 100 admissions for the month that I
need numbers for.

The floor number is in column I, the time is in column S. I need a
breakdown of each floor - how many were less than 00:45, 00:46 - 1:00, 1:01 -
1:30 and greater then 1:30.

I hope that this makes sense.