REPEAT: Repeat an action!

Why?
You want to repeat an action regularly in a spreadsheet? You can now do it without any add-ons or plug-ins or scripts.

How?
Syntax: =REPEAT(expression, interval, [start_time]).

  • Expression - the expression to be recalculated periodically.
  • Interval - the time interval in whole minutes that will lapse between value changes. The minimum value is 1 minute, the maximum value is 43200. Example: 1440 for daily repetition.
  • Start time (optional) - the time in minutes that will pass before the first execution of the timer. Any decimals are ignored.

Example: =REPEAT(NOW(),1).

Returns value: Returns value of Expression every time it recalculates according to Interval and Start time. In the example, returns a time stamp that updates every 1 minute. If you want to start the first execution only after one hour, the example would be adjusted to =REPEAT(NOW(),1,60).

Related?