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

FOM MY ECC Staging Margin Transaction Daily 01 -Cell 1 0:50:52 - Cell2 Output is coming as FOM MY ECC Staging Margin Transaction Daily 01 0.0353240740740741 I am not getting the time as 0:50:52 Please help. Thanks. <tbody> </tbody> <tbody> </tbody>

<tbody>
</tbody>

 

[Fluff]

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

 

[Allwinv]

Thank you. It is working now.

 

[Fluff]

You're welcome & thanks for the feedback