ExcelBanter - View Single Post - Convert range values to correct "hh:mm:ss" format.

[email protected]

wrote:
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.

Just a follow up,
The data for Person1, Stat1 in the original application was 1 minute
and 16 secs - 01:16 and this is in "mm:ss" but when taken to excel it
becomes 01:16:00 in "hh:mm:ss" instead of the "00:01:16" format that I
need it to be in.