You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Micki" wrote in message
...
That did it! Thanks very much.

"T. Valko" wrote:

One way.

This returns a true Excel time value...

=IF(COUNT(FIND(" ",A1)),TIMEVALUE(RIGHT(A1,FIND(":",A1)+2)),--A1)

Format as [h]:mm:ss

--
Biff
Microsoft Excel MVP


"Micki" wrote in message
...
I have raw data that downloads in 2 different formats.
451 22:07:34 (451 = # days a problem is not resolved)
3:39:10 (hrs, minutes, seconds)
I need a formula that will enter only the hrs, mins and seconds in an
adjacent column. The formula =RIGHT(A33,SEARCH(":",A33)+2) gives me the
results I need where the data in column A = 451 22:07:34, but I believe
I
also need to add an if statement to give me only the hrs, mins, sec for
the
case where the value is 3:39:10. I have tried using
=if(len(a27)8,RIGHT(A33,SEARCH(":",A33)+2),A27, but I just get #Value
return. Help is greatly appreciated.