Find top and average value from input field text H i have like 2000 nodes with field type - text field.

Purpose of that field is to be filled with best time that someone had on race. Format is something like 02:43:02 ( keep in mind that is text field and not time picker ). 

Now i have been asked to show top 10 times, and average time, and im not sure how to do math here if that is text field? 

Can views find top 10 times from text field?
The PHP function strtotime() might help you here:


  strtotime — Parse about any English textual datetime description into a Unix timestamp


For example, you could create a computed field and use that function to convert the text input to a time value.

But as you're using a text field and not a date/time filed, I doubt that you'll be able to get all values correctly (because user input can differ enormously).