Excel - Concatenate the date with time

April 2018


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.
Published by aakai1056. Latest update on June 18, 2012 at 06:39 AM by aakai1056.
This document, titled "Excel - Concatenate the date with time," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).
Microsoft Office - Recover an unsaved file
Excel - Delete part of the information from a cell