How to display time in excel

php editor Xinyi will introduce to you today how to display the time correctly in Excel. In Excel, the formatted display of time is very important, not only to make the data more intuitive and clear, but also to improve work efficiency. Through simple settings, we can easily make Excel display the time format we need, making work more convenient and efficient. Next, let us learn how to display the time correctly in Excel!

1. First enter =TODAY() in the cell where you want to display the current date, and then press the Enter key.

#2. After the input is completed, the cell will automatically display the current date, and the edit box will display the entered command.

3. If the entered information is =NOW(), the current date will also be displayed.

#4. The current date is displayed in the cell, and the entered command is displayed in the edit box, as shown in the figure below.

#5. If you want to display the time format, enter =NOW()-TODAY() in the cell.

#6. After the input is completed, the cell does not display the time format, then right-click the pop-up list box and select "Set Cell Format".

#7. In the pop-up "Format Cells" dialog box, select "Time" as the category, and then press the "OK" button.

#8. After the setting is completed, the cell will display the time format, as shown in the figure below.

When using excel, functions are often used, and the time function is one of the more commonly used ones. In fact, the time function is not just a function, it covers There are many functions, including date, time, etc. Only by practicing more can you master the use of each function.

The above is just how to display Excel dates etc. compiled by the editor for you. There are many skills about using Excel, especially data workers should master this skill. The editor hopes that everyone can spend time and energy to understand and learn this software.

The above is the detailed content of How to display time in excel. For more information, please follow other related articles on the PHP Chinese website!