Explanation
The SEQUENCE function is a dynamic array function that can generate multiple results. When used by itself on the worksheet, SEQUENCE outputs an array of results that "spill" onto the worksheet in a "spill range".
In the example shown, we want to generate 12 times, one hour apart, starting at 7:00 AM (the value in B5). To do this, we use the TIME function, which can create a valid Excel time with hours, minutes, and seconds given as decimal values.
To create the numbers used for hours with SEQUENCE, we have:
SEQUENCE(12,1,HOUR(B5))
The HOUR function is used to convert the time in B5 to a decimal value for hours (7). So the function resolves to:
SEQUENCE(12,1,7)
which generates an array of numbers like this:
{7;8;9;10;11;12;13;14;15;16;17;18}
This array is returned to the TIME function as the hour argument:
=TIME({7;8;9;10;11;12;13;14;15;16;17;18},1),0,0)
The TIME function returns 12 times to a spill range beginning in cell D5.
With raw numbers
The example above used the TIME function for convenience, but it is also possible to work with numeric values directly. Since Excel time is recorded as fractions of a day, the formula above can be written like this:
=SEQUENCE(12,1,B5,1/24)
Related formulas
Sequence of months
Sequence of years
Sequence of days
Related functions
SEQUENCE Function
The Excel SEQUENCE function generates a list of sequential numbers in an array. The array can be one dimensional, or two-dimensional, determined by rows and columns arguments.
TIME Function
The Excel TIME function is a built-in function that allows you to create a time with individual hour, minute, and second components. The TIME function is useful when you want to assemble a proper time inside another formula.
