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 copy each row 5 times ✓ - Forum - Excel
- Excel duplicate each row x times - Forum - Excel
- How to duplicate rows x number of times - Forum - Excel
- Excel insert copied cells multiple times ✓ - Forum - Office Software
- Excel - Insert current date or time - How-To - Hardware
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).
