I have rows of time values with some of them having specific text in them.. example a below.
<tbody>
</tbody>
Can you suggest a formula to get the below values. The specific text is (out) and (in)
<tbody>
</tbody>
Any help would e appreciated
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