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...
Dates are integer value as plain number and times are decimal value. So, you can sum them together to represent date/time value. As HansVogelaar​ mentioned in his answer that you can just sum them like =A1+B1 then apply desired date/time cell formats. In addition, you can sum and then can use TEXT() function after summing date and time. Try-
=TEXT(A1+B1,"d/m/e hh:mm:ss")