How Does Excel Automatically Record the Time of Data Entry?

Date:2020-11-2 Author:Sandra

In our daily work, sometimes we will often enter the current time in the form. But every time we enter it manually, is there a faster way? Today, the author will introduce to you a method of automatically recording the time of data entry. This can help us quickly improve office efficiency.

Open an Excel table, the next steps will realize that after inputting the content in A2, the time of data or content entry will automatically appear in B2.

In our daily work, sometimes we will often enter the current time in the form. But every time we enter it manually, is there a faster way? Today, the author will introduce to you a method of automatically recording the time of data entry. This can help us quickly improve office efficiency.

Open an Excel table, the next steps will realize that after inputting the content in A2, the time of data or content entry will automatically appear in B2.

Step1: Enter Formula

First, we need to enter the formula in B2=IF(A2=””,””,IF(B2=””,NOW(),B2)), and then fill it down.

How Does Excel Automatically Record the Time of Data Entry?

Step2:Enable Iterative Calculation

Click [File]→[Options]→[Formulas]→[Enable Iterative Calculation]

How Does Excel Automatically Record the Time of Data Entry?

Step3: Custom Type

After completing the previous two steps, we enter the content in the column A cell, a string of numbers will appear in the corresponding column B cell. Now we only need a simple last step, and we will get the data entry time in column B.

How Does Excel Automatically Record the Time of Data Entry?

We first click the mouse to select the cell in column B where the formula has been entered. Then click the right mouse button to set the [format cell]. We enter [yyyy/mm/dd hh:mm:ss] in the custom type.

How Does Excel Automatically Record the Time of Data Entry?

Now, after you enter any content in column A, the time of content input will appear in the corresponding cell of column B.

The author hopes that this method can help you and improve your office efficiency. Ways to improve office efficiency

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *