Five people waited 4, 5, 6, 7 and 28 minutes. Put those waits in B2:B6. =MEDIAN(B2:B6) gives 6 and =AVERAGE(B2:B6) gives 10.
Read the middle position first
Sort a copy of the five numbers and find the third position. The 28-minute wait stays in the sample and affects the mean. In a short report, write “median 6 minutes, 5 waits, longest 28 minutes.”

Illustrated odd-sample check.
Add an observation and recalculate
Put 8 in B7 and extend the median range. In order, the third and fourth values are 6 and 7, so the median is 6.5. Check that each input is a numeric measurement in minutes and that a recorded zero has a clear meaning.

Illustrated even-sample check.



