Now if we simply sum the Date and Time, our problem is solved. As the sum won’t interfere with each other.
In the example, we have a date given in the cell J34 and time in the cell K35.
We try to find the combined date and time in the cell L35.
The formula used is =CELL CONTAINING DATE +CELL CONTAINING TIME
It’ll result in the combined date and time.
In our example date is 26 june 2020 and time is 3:30 pm.
the combined result is 26-06-2020 15:30 which is as expected.
We can change the format using TEXT FUNCTION easily.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE