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.
Related
- 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 a number 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).
Subscribe To Our Newsletter!
