Excel - Concatenate the date with time

Latest update on June 18, 2012 at 06:39 AM by aakai1056 .

Issue
Solution

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.

Excel - Concatenate the date with time
Excel duplicate each row x times ✓ - Forum - Excel
Excel concatener - How-To - Excel
Excel - Insert current date or time - How-To - Hardware
Excel - Concatenate multiple tables - How-To - Excel
Excel repeat cell value x times - How-To - Excel

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 (ccm.net).

Excel - Enter text in bold for a particular cell

Excel - Determine the number of years from a date

Issue

Solution

Subscribe To Our Newsletter!