Are the race numbers in a separate cell to the race times and the race dates, if so convert the cell with race time to 24 hour time.

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________