You'd have to use a different formula in column in E1.

=IF(ISNUMBER(d1),d1,IF((LEN(d1)-LEN(SUBSTITUTE(d1,":","")))=1,
--("0"&d1)/60,--("0"&d1)))

But I'm not sure what :49:12 meant.

So that last portion is still a guess.

wrote:

Thanks Dave,

It work almost fine, just that I should have clarified that the data
Person1, Stat2 01:09:25 when taken to excel is actually in the correct
format (hh:mm:ss) and does not need to be converted to anything, it
just needs to be left alone.

How can I tweak the formula to include this possibility.

thanks.

--

Dave Peterson