Excel automatically records the time of data entry, this function is worth learning!

2020-11-22 22:16:10 0 Comment 292 views
abstract

Today we will introduce the time when data is often entered in Excel when making financial or warehouse management forms in order to make correspondin

Today we will introduce the time when data is often entered in Excel when making financial or warehouse management forms in order to make corresponding records. If you can save the manual input, you can save a lot of work, so today I will teach you how to automatically record the time of the input data. Next, let's look at:

Excel automatically records the time of data entry, this function is worth learning!

方法 : Excel Automatically record the time of data entry Production method

Method/Step 1:

First we put A2 is set as the input content. When A2 is input, the corresponding input time will be displayed in B2. We first enter the formula "=IF(A2="","",IF(B2="",NOW(),B2)) in the B2 column. , After the input is complete, drag it down to fill.

Excel automatically records the time of data entry, this function is worth learning!

Method/Step 2:

Select the upper left window "WPS Form" or click "Tools" Select bottom "Options" Click " Iterative calculation " in "Recalculation" on the left, check the front box. Or select "File", click "Options", select "Formula", click "Calculation option" on the left, check the box in front of "Workbook calculation" and click OK, we will find that you enter data in column A. , You will find that a string of data will be displayed in column B, because the operation has not ended yet.

Excel automatically records the time of data entry, this function is worth learning!

Method/Step 3:

We select column B and right-click to select "Set cell format " Click"number"choose "custom" at the bottom, enter "yyyy/mm/dd hh:mm:ss" in "type" column and click determine.

Excel automatically records the time of data entry, this function is worth learning!

Method/Step 4:

Then we drag the time bar down and enter data in the input content bar. At this time, the time of data entry can be automatically recorded when data is entered.

Excel automatically records the time of data entry, this function is worth learning!

Does this function save you a lot of time and workload? If you don’t understand, you can comment and leave a message for interaction!

For more basic functions of Excel, please pay attention to "Sound of One Song"

avatar