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.

In the sample, Q1 is 5 and Q3 is 12. Their difference is 7.

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.

Replacing the maximum 30 with 100 changes the full range and leaves the IQR at 7.

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

Microsoft’s QUARTILE.INC function reference