formula needed to extract time from text please :)

[maltait]

Hi All,

I'm needing a formula or assistance please in pulling out the time from the below fields:

In this example I want to copy the 12:36:29 from A1 to B1
Similar for A2, copy the 12:38:54 to B2

Thanks for any assistance

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]12:36:29 user not ready OPD after call work 00:00:00[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]12:38:54 user ready 00:00:00[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

Based on those two examples ..

=LEFT(A1,8)+0

then format column B with the appropriate Time format.

 

[maltait]

Fantastic, thanks peter!

 

[Peter_SSs]

Fantastic, thanks peter!

You're welcome.