Extracting h:mm:ss from text string
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.
|