[Excel] Concatenate the date with time

Issue

I have a date in a cell (A1) in the dd/mm/yyyy format, generated by the today() function.

• In another cell (B1), I have the time, in the hh:mm format,)generated by the TIME() function.
• I want to concatenate both in cell (C1), to get data in this format "dd/mm @ hh:mm".

Actually I'm doing it manually, can it be done via a macro.

Solution

No need to concatenate date and time , simply use the Now() function.

See also

Knowledge communities.

• Forum
• Excel forum
• Office software forum
• Opinions about FAQs

This document entitled « Excel - Concatenate the date with time » from Kioskea (en.kioskea.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.