I am creating a worksheet that has minimum and maximum times for completing specific mechanical tasks. I want to compare the actual time technicians take versus the minimum / maximum time and display some sort of character for a dashboard. This way we can celebrate the times we repaired items between the minimum / maximum and focus training primarily upon the tasks we failed. Would love help creating the formula for this? I presume it would be an If / Then statement but not sure.
Solved by O. S. in 23 mins