Forum Discussion
Date time format
Hi I have the following data.. Time date date_time 00:00:11 25/12/2025 25/12/2025 00:00:11 00:00:18 25/12/2025 25/12/2025 00:00:18 00:00:20 25/12/2025 25/12/2025 00:00...
CONCATENATE returns a text value, regardless of the formatting of the cell with the formula.
Change the formula to
=A2+B2
and format as dd/mm/yyyy hh:mm:ss