Creating a hour-minute table (every minute of the day)

[Jeff91]

Hi everyone,

I was wanting to know if there was a way to create a table that contains every minute of the day, for all 24 hours, in 24 hour time format (hh-mm).

Thank you,

[Melissa]

Hi @Jeff91,.

You can find an example of a time table in the M showcase category.

Time Table (Power Query M function)

Hi everyone, @DavidNealon thought it would be a nice addition if there was a Time Table Power Query M code function available in this category as well. Now I can’t take any credit because it was designed by Gina Meronek, you can find it and the full article she wrote here. When invoked the function creates a Time Table at a granularity of Minutes. If your requirement is different that can easily be fixed. Note that other changes might be required as well but to give you some ideas: For Hourl…

I hope this is helpful

[sprmnt21]

try this

 List.Transform(List.Times(Time.From(0),60*24,#duration(0,0,1,0)), each Text.Replace(Time.ToText(_),":","-"))

if you do not have a strict requirement on the format and you are happy with the standard, the solution is much shorter

List.Times(Time.From(0),60*24,#duration(0,0,1,0))

[Jeff91]

This is great, thank you so much

[Jeff91]

This works too, thank you!!