PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
The procedure of INSERTING CURRENT DATE AND TIME IN EXCEL.
Many times, the current date and time are needed in our applications.
We can insert the current date and time easily.
Let us try to understand the example.
CURRENT DATE:
We have to find the current date in the cell G7 and the current time in the cell G9.
For the current date, we can use a direct function TODAY() which provides us the CURRENT DATE.
CURRENT TIME:
We want to find the current time in the cell G9.
We have a problem with the current time. We don’t have any direct function to find out the current time.
But we can get the current time using the combination of two functions which are NOW() function and TEXT function.
The TEXT FUNCTION is used to change the format of the contents of a cell. [CLICK HERE TO LEARN TEXT() FUNCTION ]
NOW() Function produces the complete time including the date. [CLICK HERE TO LEARN ABOUT NOW() FUNCTION ].
Put the following function
=TEXT ( Now (),”HH:MM”)
The NOW() function will give the complete time with date ( for example 07-31-2020 20:42) . This output will be put into the TEXT() function and gives the output in the format, which we have mentioned in the formula i.e. hh:mm. So the output will be 20:42.
In the example , the time is 23:01 which is our answer.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE