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.

8:00 ​

9:41​

11:48 (Out)

12:52 (In)

13:01​

13:01​

13:02​

13:08​

0:00 ​

0:00 ​

<tbody>
</tbody>

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

8:00​

9:41​

11:48

12:52

13:01​

13:01​

13:02​

13:08​

0:00 ​

<tbody>
</tbody>

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.

8:00 ​

9:41​

11:48 (Out)

12:52 (In)

13:01​

13:01​

13:02​

13:08​

0:00 ​

0:00 ​

<tbody>
</tbody>

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

8:00​

9:41​

11:48

12:52

13:01​

13:01​

13:02​

13:08​

0:00 ​

<tbody>
</tbody>

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..