How to automatically change the table time data

To record the entry time of a certain cell content, if the manual input time is not a problem, but if you want to enter a lot of data, each data requires record entry time, the first input time is troublesome. some. But if you only use a simple NOW() function to get the current time and fill it in batches, you can't achieve time difference records for different cells at all. How to automatically record the entry time in different cells, and ensure that the time to re-enter after deleting the data also changes? To record the number of component inspections completed by the team members in the form, the employee automatically records the time of completion after filling in the data (Figure 1). After each member of the team is required to complete the task, open the form and fill in the number of completions in the “Number of Completions” field after the name, “Complete Time”, the cell automatically displays the completion time, no manual input is required. And if the completed quantity is emptied and re-entered, the subsequent time record is also updated. Take the latest version of the WPS table as an example. Use two simple functions to fill the handle with the worksheet, and then perform two important settings to complete the above task. The specific idea of ​​the constructor: If the C column "Complete Quantity" is filled in the data, the WPS table automatically fills in the current time in the D column "Completion time"; if the C column is a cell Empty, then the WPS table will automatically determine the empty state, automatically clear the contents of the D column. To achieve this, enter the following formula in the D2 cell (as shown in Figure 1): =IF(C2="","",IF(D2="",NOW(), D2)) After entering the formula, click the small black square (fill handle) in the lower right corner of the D2 cell, and press the left mouse button to drag down to the last data of the column (or double-click the fill handle fill). Note that you also need to set the data type of all cells in column D to a custom date type. Select column D, right click and select “Set cell format”, then select “Custom →yyyy/m/dh:mm AM/PM” (Figure 2) under the "number” tab .