how to remove text and retain only the numbers in time format

[billy_br]

I have rows of time values with some of them having specific text in them.. example a below.

[TABLE="width: 332"]
<tbody>[TR]
[TD="width: 47, bgcolor: transparent"]

8:00
​

[/TD]
[TD="width: 39, bgcolor: transparent"]

9:41​

[/TD]
[TD="width: 75, bgcolor: transparent"]11:48 (Out)
[/TD]
[TD="width: 64, bgcolor: transparent"]12:52 (In)
[/TD]
[TD="width: 39, bgcolor: transparent"]

13:01​

[/TD]
[TD="width: 39, bgcolor: transparent"]

13:01​

[/TD]
[TD="width: 39, bgcolor: transparent"]

13:02​

[/TD]
[TD="width: 39, bgcolor: transparent"]

13:08​

[/TD]
[TD="width: 32, bgcolor: transparent"]

0:00
​

[/TD]
[TD="width: 32, bgcolor: transparent"]

0:00
​

[/TD]
[/TR]
</tbody>[/TABLE]


Can you suggest a formula to get the below values. The specific text is (out) and (in)

[TABLE="width: 308"]
<tbody>[TR]
[TD="width: 47, bgcolor: transparent"]

8:00​

[/TD]
[TD="width: 39, bgcolor: transparent"]

9:41​

[/TD]
[TD="width: 75, bgcolor: transparent"]11:48[/TD]
[TD="width: 64, bgcolor: transparent"]12:52[/TD]
[TD="width: 39, bgcolor: transparent"]

13:01​

[/TD]
[TD="width: 39, bgcolor: transparent"]

13:01​

[/TD]
[TD="width: 39, bgcolor: transparent"]

13:02​

[/TD]
[TD="width: 39, bgcolor: transparent"]

13:08​

[/TD]
[TD="width: 32, bgcolor: transparent"]

0:00
​

[/TD]
[/TR]
</tbody>[/TABLE]


Any help would e appreciated

 

[Rick Rothstein]

I have rows of time values with some of them having specific text in them.. example a below.

[TABLE="width: 332"]
<tbody>[TR]
[TD="width: 47, bgcolor: transparent"]

8:00
​

[/TD]
[TD="width: 39, bgcolor: transparent"]

9:41​

[/TD]
[TD="width: 75, bgcolor: transparent"]11:48 (Out)[/TD]
[TD="width: 64, bgcolor: transparent"]12:52 (In)[/TD]
[TD="width: 39, bgcolor: transparent"]

13:01​

[/TD]
[TD="width: 39, bgcolor: transparent"]

13:01​

[/TD]
[TD="width: 39, bgcolor: transparent"]

13:02​

[/TD]
[TD="width: 39, bgcolor: transparent"]

13:08​

[/TD]
[TD="width: 32, bgcolor: transparent"]

0:00
​

[/TD]
[TD="width: 32, bgcolor: transparent"]

0:00
​

[/TD]
[/TR]
</tbody>[/TABLE]


Can you suggest a formula to get the below values. The specific text is (out) and (in)

[TABLE="width: 308"]
<tbody>[TR]
[TD="width: 47, bgcolor: transparent"]

8:00​

[/TD]
[TD="width: 39, bgcolor: transparent"]

9:41​

[/TD]
[TD="width: 75, bgcolor: transparent"]11:48[/TD]
[TD="width: 64, bgcolor: transparent"]12:52[/TD]
[TD="width: 39, bgcolor: transparent"]

13:01​

[/TD]
[TD="width: 39, bgcolor: transparent"]

13:01​

[/TD]
[TD="width: 39, bgcolor: transparent"]

13:02​

[/TD]
[TD="width: 39, bgcolor: transparent"]

13:08​

[/TD]
[TD="width: 32, bgcolor: transparent"]

0:00
​

[/TD]
[/TR]
</tbody>[/TABLE]

Give this formula try...

=0+LEFT(A1,FIND(" ",A1&" ")-1)

 

[billy_br]

Give this formula try...

=0+LEFT(A1,FIND(" ",A1&" ")-1)

Thank you very much..