List.Times
A list of times of day from a start, a set count of them, each a step from the last.
Group: List. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
List.Times(start as time, count as number, step as duration) as list| Parameter | Type | Description |
|---|---|---|
start | time | The first time. |
count | number | How many times. |
step | duration | The time between them. |
Returns
list. The times.
Examples
Opening hours in half hours
List.Times(#time(9, 0, 0), 4, #duration(0, 0, 30, 0)){#time(9, 0, 0), #time(9, 30, 0), #time(10, 0, 0), #time(10, 30, 0)}