How to Change a Cell from A to B After 15 Minutes in Excel
Question details
The user needs a way to automatically change a cell value from A to B after 15 minutes in Excel, combining a helper time cell with a timer macro because formulas alone do not create a timer.
- Product
- WPS Office Spreadsheet
- Device & OS
- not provided
- Scenario
- The user wants a cell that initially shows A to switch to B automatically after 15 minutes, without manually recalculating or editing the cell.
- Observed behavior
- A standard Excel formula does not act as a timer; it only recalculates when triggered, and NOW() alone does not update the displayed result after 15 minutes.
Before you begin, save the workbook as a macro-enabled .xlsm file and enable macros if prompted. Identify the value cell (for example A1), the result cell (B1), and the helper time cell (C1) so the timer macro updates the intended range.
Use a static helper time and a NOW() comparison formula
Use this formula-only approach when a recalculation trigger such as F9, reopening the workbook, or another cell change is acceptable.
Select cell C1 and press Ctrl+Shift+; to insert the current time as a fixed value. If the shortcut is not available, type the time manually in a time format.
Select cell A1 and type A, or place an existing value that should be checked after the time delay.
Select cell B1 and enter =IF(A1="A",IF(NOW()>=C1+TIME(0,15,0),"B","A"),""). This returns B when C1 plus 15 minutes is reached, otherwise A.
Press F9 to recalculate the workbook. If 15 minutes have passed since C1, B1 changes to B; otherwise it remains A.
Use a VBA Application.OnTime macro to recalculate automatically
Use this macro solution when the cell must change from A to B after 15 minutes even if no other data changes and no one manually recalculates the workbook.
Set a Timed Auto-Change from A to B in WPS Office Spreadsheet
Use a helper time cell and a small VBA Application.OnTime macro in WPS Office Spreadsheet to schedule recurring recalculation, so the displayed value changes from A to B automatically after 15 minutes without manual intervention.
- 1. Save as a macro-enabled workbook: Open your file in WPS Office Spreadsheet, click Menu > Save As, and choose Excel Macro-Enabled Workbook (*.xlsm).
- 2. Open the VBA editor: Press Alt+F11 to open the WPS Visual Basic Editor and insert a standard module.
- 3. Paste the timer macro: Add a macro named UpdateValue that recalculates the result cell and then schedules itself with Application.OnTime every minute.
- 4. Start the timer: Run the UpdateValue macro from the editor or the Developer tab to begin automatic recalculation.
Frequently Asked Questions
Will the formula update automatically without any macro?
No. A standard Excel or WPS formula only recalculates when the workbook opens, when cells change, or when you press F9. To update automatically after 15 minutes, use the VBA Application.OnTime macro.
Why does my timer formula still show A after 15 minutes?
The workbook probably has not recalculated. Press F9 to test, check that C1 contains a fixed start time, and ensure the macro-enabled workbook is saved as .xlsm.
Can I use this timer in WPS Office Spreadsheet?
Yes. WPS Office Spreadsheet supports VBA macros and macro-enabled .xlsm files. Press Alt+F11 to open the editor and use the same Application.OnTime method.
Do I need to enable iterative calculation?
Only if you use a self-referencing helper formula. The recommended method uses a static start time in C1, so iterative calculation is not required.
How do I stop the recurring timer?
Close the workbook or stop the scheduled macro. You can also modify the VBA code to schedule only one update instead of repeating it every minute.
