One request took 30 minutes when the rest were faster. Use the interquartile range to describe the middle spread, then keep the longest wait visible if it matters to the reader.
Subtract the first inclusive quartile from the third
Enter 3, 5, 8, 12 and 30 in B2:B6. For these five readings, QUARTILE.INC gives 5 for Q1 and 12 for Q3.
=QUARTILE.INC(B2:B6,3)-QUARTILE.INC(B2:B6,1)The IQR is 7 minutes.

Illustrated quartiles. Both endpoints use QUARTILE.INC.
Replace the highest value and compare the two measures
Change 30 to 100. The full range changes from 27 to 97 minutes, while the IQR stays 7 in this sample. Label the method when comparing two teams, since other quartile conventions can give different values. Keep the units and inclusion rules consistent, and report the largest delays separately when they matter.

Illustrated sensitivity test. Compare groups with the same method and units.



