let
Dates = Table.FromList(
List.Times(#time(0,0,0), 24*60*60, #duration(0,0,0,1)),
Splitter.SplitByNothing(), null, null, ExtraValues.Error),
Rename = Table.RenameColumns(Dates,{{"Column1", "Time"}}),
Type = Table.TransformColumnTypes(Rename,{{"Time", type time}}),
Hour = Table.AddColumn(Type, "Hour", each Time.Hour([Time]), Int64.Type),
Min = Table.AddColumn(Hour, "Minute", each Time.Minute([Time]), Int64.Type)
in
Min
let
Dates = Table.FromList(
List.Times(#time(0,0,0), 24*60*60, #duration(0,0,0,1)),
Splitter.SplitByNothing(), null, null, ExtraValues.Error),
Rename = Table.RenameColumns(Dates,{{"Column1", "Time"}}),
Type = Table.TransformColumnTypes(Rename,{{"Time", type time}}),
Hour = Table.AddColumn(Type, "Hour", each Time.Hour([Time]), Int64.Type),
Min = Table.AddColumn(Hour, "Minute", each Time.Minute([Time]), Int64.Type)
in
Min