Home  >  Article  >  Topics  >  How to enter time in excel

How to enter time in excel

藏色散人
藏色散人Original
2020-02-14 10:20:366901browse

How to enter time in excel

Excel time input method

When using Excel, you often enter the current time. If you need to enter If the number of times is large, it will be a waste of time to input by pressing the numeric keys of the keyboard each time. Today we will learn how to quickly enter the current time.

1. Excel shortcut key to quickly enter time

In the excel table, we can use the shortcut key CTRL SHIFT; to quickly enter the current time, we first select a cell , and then press the CTRL SHIFT ; shortcut key, the current time will be entered in the currently selected cell. The current time format is hour:minute:00, and only 00 will be displayed for seconds. CTRL SHIFT ; Pronunciation

2. Excel function to quickly enter time

In the excel table, we can quickly enter the current time through the now function. We enter the formula in the cell. =now(), the generated time will be automatically updated every day with the time in the computer system (you need to double-click the cell, the current time will be automatically updated after exiting, or the excel sheet will be updated to the current time when you reopen it), thus avoiding the need to Re-enter the current time.

This method will generate year/month/day hour:minute date format by default. If we only need to display the time, we can right-click the cell, select "Format Cells" - select the "Time" category in the "Number" tab, and then select a time type. Just remove the year, month and day. now pronunciation

How to enter time in excel

Figure 1. Now function quickly enters the current time

How to enter time in excel

Figure 2. Set cell time format

How to enter time in excel

Figure 3. The result after setting the cell time format

If we don’t want the time to change in real time, we can "Copy" - "Paste Special" - The "numeric" method fixes the time.

For more Excel-related technical articles, please visit the Excel Basic Tutorial column!

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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn