Hi,

Our target is 75 seconds or less and it should be equivalent to 10% weight out of 100% on our scorecard.

So, if someone gets more than 75 seconds, the 10% weight will decrease.

Can someone please help me in the formula?

Thanks!