Copy time formatted cell

[pacman65]

Hi Folks

I'm trying to join the content of two cells: one of them is in the format 10:40:15, and the other is in the format 11/11/2015. When I try to concatenate the contents of both cells to get something like "11/11/2015 10:40:15", the date field format goes ok, but the one with the time format converts to 0,448..., resulting in "11/11/2015 0,448...".

Any guess?

Thank you very much for your help

 

[Declamatory]

Try =CONCATENATE(TEXT(A1,"DD/MM/YYYY"),TEXT(B1," HH:MM:SS"))