It doesn't work.

Please try this
=concatenate(text(A2;"mm/dd/yyyy")&" "&text(B2;"hh:mm:ss"))

Same error to me

It doesn't work. I do not understand the message below. I don't need it explained to me. I just need a formula that works please. Thank you.
"There's a problem with this formula.
When trying to insert the formula Excel replies:

If you type: =1=1, cell shows : 2
To get around this, type an apostrphe (') first:
But if you type: '=1=1, cell shows: =1+1"
Why ?

How do i make a graph in excel using the y-axis as hours and x-axis as date.

I get the result like: 01/10/yyyy 14:15:00.000+03:00
Do you know how to remove the yyyy and get the actual year?
And do you know how to remove the GMT + 3 to a fixed hour?

Thanks

Awesome, thank you! works perfectly on Google Sheets as well!

After struggling for 30 minutes with this thing and getting results like "14/05/yyyy hh:12:02", I finally cracked the code. Instead of =concatenate try using basic =A2+B2...

i just combine date and time cell using this formula but why it doesn't work on graph?
on graph show 00-01-1900 12:00:00AM

Thank you for solving a problem that I have been wrestling with for the longest time!  None of the "help" on CONCATENATE worked for me, but your formula above worked instantly.  Fabulous!

It doesn't work. I do not understand the message below. I don't need it explained to me. I just need a formula that works please. Thank you.
"There's a problem with this formula.
Not trying to type a formula?
When the first character is an equal(=) or minus (-) sign, Excel thinks it's a formula.
you type: =1=1, cell shows : 2
To get around this, type an apostrphe (') firts:
you type: '=1=1, cell shows: =1+1"
I have replaced the rows and cells numbers and letters and have done it several times.

Apologies, I want to withdraw my previous comment. (I copied and pasted the formula, and I now realise that I can change the format.)