combining 2 formulas i.e. =Right and =Left to save time

[cantdoit]

Hi Everybody,

Can someone join Formula #1 and formula #2 into one:

Eg of text string in A1: "Line 1884: 10:28:24.817 00000015 I Activity Duration: 00:00:25.3812446 - activity"

Formula #1 in cell B1 "=RIGHT(A1,LEN(A1)-FIND("n: ",A1)-2)"

Formula #2 in cell C1 "=LEFT(D1,FIND(".",D1)-1)"

I only want the time [hh:mm:ss]

Thanks, guys

 

[Joe4]

Welcome to the Board!

Your question is missing something. Formula 2 references cell D1, but you haven't told us what is in cell D1.

 

[Scott Huish]

Is this what you need?

=LEFT(REPLACE(A1,1,FIND("Duration:",A1)+9,""),8)+0

Format as [hh]:mm:ss

Excel 2010
	B	C
1	Line 1884: 10:28:24.817 00000015 I Activity Duration: 00:00:25.3812446 - activity	00:00:25
Sheet1

Cell Formulas
Range	Formula
C1	=LEFT(REPLACE(A1,1,FIND("Duration:",A1)+9,""),8)+0

 

[cantdoit]

@Scott Huish YES that did it!
You are a master!!!
Thank you,
OMG we are so happy now :DD