Excel - Concatenate the date with time

October 2016


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.


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

Related :

This document entitled « Excel - Concatenate the date with time » from CCM (ccm.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.