BEFORE READING THIS ARTICLE , IT IS REQUESTED TO VISIT THE PART I WHICH DISCUSSES THE CONCEPT OF THE DATE AND TIME IN EXCEL FOR BETTER UNDERSTANDING.CLICK HERE TO VISIT.
A situation can arise where we need to add some time[in hours, minutes or seconds] directly to the given time.
We can add this time by making use of the TIME FUNCTION.
Suppose we have time in cell D4 and we need to find out the time after 3 hrs 15 minutes.
The time is present in the cell D4.
WE NEED TO FIND THE TIME AFTER THREE HOURS AND FIFTEEN MINUTES IN THE CELL E4.
We simply add the time using the TIME FUNCTION to the time present in a cell.
TIME(3,15,0) means 3 hrs, 15 minutes and 0 seconds and they are being added to time present in the address D4.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE