Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    6 years ago

    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's avatar
v-chuncz-msft
Community Support
6 years ago

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))

 

yyyyyyyy's avatar
yyyyyyyy
New Member
1 year ago

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?