Sunday, May 31, 2015

What Does It The Excel Function =NOW() Use For? | Exceltip2day Blog

🔓Solved YOU! work in the office, study or whatever you do, if you use the Excel office program for your job. We would like to share with you the formula find out the auto-updating current time.  



In the Excel office program, there are many functions to help users to handle their job easily.

Today, this blog, “Exceltip2day”, is going to describe you the method of how to find out the “CURRENT TIME” with formula in an Excel worksheet.

The following is the syntax of Excel function to solve the current time:

=now()

The benefits of formula:

It will give the automatically updating date and time whenever that Excel sheet file is opened, - auto refresh.

See the image below for more easier understanding.

To fill out the syntax formula into a cell.

 The date/time value is given as above

In addition, the image that below is to tell you how to use the function “Format Cell” to adjust your value feature, as you want.


Does it help?
Mhchael Leng

See more other tips:
Would you like to surf more my other blogs?