Timer non-VBA solution

Johnpow

New Member
Joined
Feb 19, 2017
Messages
18
Hello everyone,

Using Excel 2010 - Is a formula possible to place in a cell and countdown time from another preset cell as would be used in a timed event - like NBL?

The process being:

Preset cell A4 at say 50:00 (mm:ss format)
Cell B4 (mm:ss format) to have a formula which counts down from 50:00 to 00:00 by seconds.
When B4 reaches 00:00, B4 stays at 00:00 and A4 resets to 00:00, until it is reset to say 50:00, when B4 starts over again and so on.

Whilst not out of the question, prefer non-VBA solution as I want to run on an iPad which does not support VBA.

Thanks
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,257
Office Version
  1. 2013
Platform
  1. Windows
You won't get a non VBA solution.....if you google "Excel Countdown timer for Ipad"
There are many to choose from, so you will have to decide which one suits your needs best.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,109,001
Messages
5,526,203
Members
409,686
Latest member
Tori83

This Week's Hot Topics

Top