Max, Min, Median but without Outliers

[greenstar]

Hi

I have a time column [H]:MM I am calculating the following using the adjacent formulas

Please Login or Register  to view this content.

How can I make MAX, MEDIAN and MIN ignore 5% outliers just like it does with MEAN (Trimmean) ?

Thanks

[greenstar]

Example of how TRIMMEAN() calculates an outlier:

TRIMMEAN rounds excluded data points down to the nearest multiple of 2.

For example, with 50 data points, 10% equals 5 values. In this case, TRIMMEAN will round 5 down to 4, then exclude two values from the top, of the data set, and two values from the bottom of the data set.

[greenstar]

I guess what I am saying is, if I can get Max/Median/Min to remove a % I give it from the top and bottom values that will also do the job.