I am a track coach and we record the distances thrown for shotput and discus and currently enter it as "feet-inches" so a shotput throw of 45 feet 6 inches is recorded at 45-06 and a throw of 46 feet 2 1/4 inch is recorded 46-0225. We track every throw from every meet in a spreadsheet throughout the season. We need to find the highest value and return that value in the same format (45-06). Below is a sample of what our data looks like:
Is there an easy way to find the max value and return it in the same format? Or is there an easier way to enter the distance in feet & inches that would make it easier to use? I don't want to have to convert their distance to inches as we need it in Feet & Inches.
| Name | Season Best | Meet #1 | Meet #2 | Meet #3 | Meet #4 |
| Parker | 45-06 | 44-11 | 46-0225 | 45-07 | |
| Dean | 44-04 | 44-0975 | 43-01 | 47-00 |
Is there an easy way to find the max value and return it in the same format? Or is there an easier way to enter the distance in feet & inches that would make it easier to use? I don't want to have to convert their distance to inches as we need it in Feet & Inches.
