How to use excel to make a dynamic countdown accurate to seconds, such as 3 days 15 hours, 20 minutes and 7 seconds?

1 and A3 automatically display the current time, while B3 is the expiration date and time entered by ourselves. Now, the countdown prompt accurate to the second is displayed in C3 cell.

2. In the Excel operation window, press Alt+F 1 1 to pop up the VBA window, and then perform the following menu operation: Insert → Module.

3. The code input window shown below pops up.

4. After the above code is successfully entered, right-click "ThisWorkbook" on the left side of the window and select "View Code", as shown below.

5. Finally, close the vba window, return to Excel to save the file, then close Excel, and then open the Excel file, and the effect will come out.

Precautions:

Although Excel provides a lot of user interface functions, it still retains the functions of the first spreadsheet software VisiCalc: rows and columns form cells, and data, formulas related to data or absolute references to other cells are stored in cells.