Create DateTime List between start datetime & end DateTime

Question

Hello&nbsp;I hope someone can help?&nbsp;I want to create a list of datetimes between a Start DateTime column and an End DateTime column in Power Query with&nbsp; 1 hour between . I have tried this but it didn't work using add Custom Column&nbsp;=&nbsp;List.DateTimes([#"Shift Start Time"], [#"Shift End Time"], #duration(0,1,0,0))&nbsp;Example&nbsp;Table currently looks like thisStart DateTime&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;End DateTime&nbsp; &nbsp; &nbsp;01/01/2020 00:00:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01/2020 04:00:00&nbsp;i want it to look like this&nbsp;&nbsp;Start DateTime&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;End DateTime&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Custom01/01/2020 00:00:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01/2020 04:00:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;01/01/2020 00:00:00&nbsp;01/01/2020 00:00:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01/2020 04:00:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;01/01/2020 01:00:00&nbsp;01/01/2020 00:00:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01/2020 04:00:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;01/01/2020 02:00:00&nbsp;01/01/2020 00:00:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01/2020 04:00:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;01/01/2020 03:00:00&nbsp;01/01/2020 00:00:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01/2020 04:00:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;01/01/2020 04:00:00&nbsp;&nbsp;I have nearly no experience with M so it I would be grateful if I could get a statement to use to create a custom column&nbsp;ThanksJoe&nbsp;

v-chuncz-msft · Accepted Answer

Anonymous&nbsp;
&nbsp;
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))
&nbsp;

Forum Discussion

Create DateTime List between start datetime & end DateTime

2 Replies

Related content

Converting Epoch Datetime into regular datetime format

Convert DateTime to Date

MAX datetime truncates to date???

datetime difference in datetime format

Get Time from DateTime field