How to automatically fill in the current time in Excel?

#How to automatically fill in the current time in Excel?

First, right-click the first cell and click [Format Cells];

Then click [Date] on the left, And select the date type;

Then enter the formula "=IF(B2="","",IF(C2="",NOW(),C2 in the table ))”;

#Finally, set the table to iterative calculation.

Recommended tutorial: "Excel"

The above is the detailed content of How to automatically fill in the current time in Excel?. For more information, please follow other related articles on the PHP Chinese website!