When exporting data from another application as an excel worksheet I
end up with it in the following format.

Stat 1 Stat 2
Person1 01:16:00 01:09:25
Person2 :18 :49:12

I want to macro that will convert all the data in the range to
"hh:mm:ss".
Just applying data type cell formatting as hh:mm:ss does not fix the
values for Person2 and seems excel just treats it as text.
What is the most efficient way to do a check of all the data and then
fix the value of the data that is not in the correct format to
hh:mm:ss.

Thanks.