PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
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