Concatenating text with with time not working.

[Allwinv]

Hi Excel experts,

I am trying to concatenate text with time. But it is not working.

For example

[TABLE="width: 511"]
<tbody>[TR]
[TD="width: 511"]FOM MY ECC Staging Margin Transaction Daily 01 -Cell 1
[TABLE="width: 104"]
<tbody>[TR]
[TD="class: xl65, width: 104, align: right"]0:50:52 - Cell2

Output is coming as [TABLE="width: 511"]
<tbody>[TR]
[TD="class: xl65, width: 511"]FOM MY ECC Staging Margin Transaction Daily 01 0.0353240740740741

I am not getting the time as 0:50:52

Please help.

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

 

[Fluff]

Try
=A1&TEXT(B1," h:mm:ss")

 

[Allwinv]

Thank you. It is working now.

 

[Fluff]

You're welcome & thanks for the feedback