How to use excel's now function

How to use excel's now function: 1. The date and time obtained by the NOW function change with the current system date and time; 2. You can press the F9 key to update the return result of this function.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to use the now function of excel:

1. The Now function is a function used to obtain the current system date and time. This function has no parameters. The date and time obtained by the NOW function change with the current system date and time. We can press the F9 key to update the return result of this function.

2. By default, the result returned by the NOW function is in the format of "2015/12/30 20:27". If we need output in other formats during use, we can do it by modifying the format of the cell.

3. For example, if we need to output the format "December 30, 2015", we only need to set the cell format to date and select the type on the right The corresponding format will do. The same goes for setting the time format.

4. In daily work, sometimes the date and time format in Excel cannot meet our requirements, then we need to customize the format. For example, if we want to output a format of "8:45:02 pm on December 30, 2015", we need to customize the format. Right-click the cell and click Format Cells.

5. Select "Custom" in "Category" in the pop-up "Format Cells" window, and then fill in the type we defined on the right. Format "yyyy "year" mm "month" dd "day" am/pm h" hour "mm" minute "ss "second"" and click OK.

#6. At this time, when we use the now function to obtain the date and time, we will get the format we want.

Related learning recommendations: excel tutorial

The above is the detailed content of How to use excel's now function. For more information, please follow other related articles on the PHP Chinese website!