Moee, re the question you asked, regarding a formula, the simple addition to the formula makes sure it converts from text to a number format all the time.
It would have little impact on the overall assessment of the animal.

One thing you should add is a filter for outliers, do a search and have a look at Grubb's test, using that I would highlight suspicious times for further analysis or delete