Excel Concatenate Date with Time Solved

Question

Hello,

I have a date in a cell (A1) in the format dd/mm/yyyy given by the formula today()
in another cell (B1) an hour in hh:mm given by the formula now().

I would like to concatenate them in a cell (C1) using a macro in the format "dd/mm @ hh:mm".

Today I do it manually (I rewrite the date and the time with an @ between them).

Does anyone have a solution for me please?

Thank you in advance

Configuration: Windows XP / Internet Explorer 7.0

Patrice33740 · Accepted Answer

Or: =TEXT(A1 + A2,"dd/mm/yyyy" " @ " " hh:mm")

Patrice33740 · Answer

No need to concatenate, NOW() directly provides the date and time; to display it, simply use the format (French): dd/mm/yyyy hh:mm -- Patrice

Mrfrize · Answer

Thank you,

I have another completely similar problem because I need to concatenate a date in dd/mm/yyyy format and a time hh:mm in dd/mm @ hh:mm.

A1: date
A2: time
A3: date @ time

Thanks in advance.

Vaucluse · Answer

Hello
maybe this
=TEXT(A1&A2,"dd/mm/yyyy" " @ " " hh:mm")
based on the principle that Patrice had indicated to us.
simply
best regards
Let's ask ourselves if we are not the only ones who understand what we are explaining?

Mrfrize · Answer

Hello, your solutions probably work but they are Excel formulas, I want to do it with a macro. It will be integrated with another one that does other things.  Thank you in advance.

Mrfrize · Answer

I managed to do this:

Dim dt, hr as Date

dt = Cells(1, 1)
dt = Format(dt, "DD/MM")
hr = Cells(2, 1)
hr = Format(hr, "HH:MM")

Cells(3, 1) = dt & " @ " & hr
Cells(4, 1) = hr => just testing.

And I still have a problem, the date is correctly formatted as dd/mm but the time is always in hh:mm:ss and I don't know why.
I would even say that in cell A4 I have a format hh:mm:ss AM/PM while I would prefer it in 24 hours.
In cell A2, however, my format is in hh:mm in 24H

Does anyone have an idea?

Thank you

Mrfrize · Answer

I finally found a solution. I don't know if it's very elegant, but it works. You have to declare the variables as strings.

Dim dt, hr as String

dt = Cells(1, 1)
dt = Format(dt, "DD/MM")
hr = Cells(2, 1)
hr = Format(hr, "HH:MM")

Cells(3, 1) = dt & " @ " & hr

Thank you for your help

Excel Concatenate Date with Time

7 answers

Open word pdf files directly without preview

Unable to connect to wifi

Hitachi 55f501hk5110

Where is the phone icon?

Bb08 repeater blocks application

Unable to rename folders and files

Prohibit excel formulas deletion 10

Canon mg 2120 printer

Secondary email bouygues telecom: how to access it...????

Projetivy launcher facturation_non_disponible