Five fictional queue times are 5, 10, 15, 20, and 25 minutes. Enter them in B2:B6 and use =PERCENTILE.INC(B2:B6,0.9).
Locate the cutoff between the last two observations
The inclusive position is 1+0.9*(5-1), or 4.6. That is 60% of the way from the fourth value, 20, to the fifth value, 25. The expected result is 23 minutes.

Illustrated interpolation. The cutoff can fall between observed times.
Test the endpoints and write down the sample size
Change the second argument to 0 and 1 in scratch cells. The results should be 5 and 25. Report the sample as “90th percentile: 23 minutes across 5 observations.” Use the same percentile convention before comparing periods, and check for blank or text inputs.

Illustrated endpoint check. Use the same input range.



