Power Query
Search…
List.Times

List.Times

Generates a list of time values given an initial value, count, and incremental duration value.
function (start as time, count as number, step as duration) as list

Description

Returns a list of time values of size count, starting at start. The given increment, step, is a duration value that is added to every value.

Category

List.Generators

Examples

Create a list of 4 values starting from noon (#time(12, 0, 0)) incrementing by one hour (#duration(0, 1, 0, 0)).
1
List.Times(#time(12, 0, 0), 4, #duration(0, 1, 0, 0))
Copied!
{
1
#time(12, 0, 0),
2
#time(13, 0, 0),
3
#time(14, 0, 0),
4
#time(15, 0, 0)
Copied!
}
Last modified 3yr ago