** EXPLANATION:**

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.