Combining Date & time

Hi Guys,

I'm having some trouble combining a date and time to form at dd/mm/yyyy hh/mm. For some reason i can't get it to work, not sure of the formatting.

Any help would be great!

Try plus instead of and in your formula.

Try

=TEXT(B2,"mm/dd/yy")&" " &TEXT(C2,"hh:mm:ss")

Dam it was that easy.

Thanks Kersplash!

No worries, send some love by clicking Add Reputation.