Forum Discussion
Create DateTime List between start datetime & end DateTime
Hello I hope someone can help? I want to create a list of datetimes between a Start DateTime column and an End DateTime column in Power Query with 1 hour between . I have tried this but it d...
Anonymous
You may use code below to add a custom column.
List.DateTimes([Start DateTime], Duration.Hours([End DateTime] - [Start DateTime]) + 1, #duration(0,1,0,0))
v-chuncz-msft
Community Support
Community SupportAnonymous
You may use code below to add a custom column.
List.DateTimes([Start DateTime], Duration.Hours([End DateTime] - [Start DateTime]) + 1, #duration(0,1,0,0))
Can you fix this so that it always end with the End Date and Time and the hours inbetweena are rounded to the end of the hour?
