=1-ActualMinutes/(AllowedMinutes*0.75)+100%
ActualMinutes & AllowedMinutes are fields in a Table.
=1-ActualMinutes/(AllowedMinutes*0.75)+100%
ActualMinutes & AllowedMinutes are fields in a Table.
Maybe something like this ...
=(1-(ActualMinutes/(AllowedMinutes*0.75)))*2
However, I would probably approach this with VBA and assign a couple of those equations to variables.
Maybe you could provide data? 3 - 5 examples?
ActualMinutes
AllowedMinutes
Expected results
What does the 100% represent?
The 100% is the standard quantity we are certain our employee can meet. We are pushing them to try to exceed it by 25% more.