How to find inside a string to do time calculation

Hi there! It looks like you’re trying to find a specific string (player name) within a column in Excel and use that information to calculate the time on court for each player.

There are several ways you can do this in Excel, including using functions such as SEARCH, FIND, MATCH, and COUNTIF1234.

For example, you can use the SEARCH function to find the position of a specific substring within a text string. The SEARCH function is not case-sensitive and supports wildcards, which can be useful when searching for substrings. You can also use the ISNUMBER function in combination with the SEARCH function to return a TRUE or FALSE result indicating whether the substring was found1.

Another option is to use the MATCH function to find the position of a specific value within a range or array. This function can be useful when you want to find the row number of a specific value within a column3.

I hope this information helps! If you need more detailed instructions or examples, I recommend checking out some of the resources I mentioned above. Let me know if you have any further questions 😊.