Thank you very much for all your help. It turns out the current formula is not entirely correct. Can you help me again, please?
The formula needs to approximate the time value. After converting to seconds, Excel looks for the value from column C. If the swimming time in seconds exactly matches...
I want a formula in column F that shows the score out of 20 based on the swimming time. The swimming time is in column F. The first digit in column F represents the number of minutes. The last two digits of column F represent the number of seconds. I would like to see the number in column F...
