List.Times

The function returns a list of time values with a specified count, beginning at the starting time. The increment, represented as step, is a duration value that is added to each time value in the list.

Syntax

List.Times(start as time, count as number, step as duration) as list

About

The function returns a list of time values with a specified count, beginning at the starting time. The increment, represented as step, is a duration value that is added to each time value in the list.

Explanation

Generate a list of 4 values starting from noon (12:00:00 PM) and increasing by one hour using Power Query MList.Times function: MList.Times(#time(12, 0, 0), 4, #duration(0, 1, 0, 0)) Output: { #time(12, 0, 0), #time(13, 0, 0), #time(14, 0, 0), #time(15, 0, 0) }