Power Query, return Time Range from Time

[joand]

I am fairly new with Power Query. I have a two tables: one named DataExport which contain the column [Time] and another table named Time Range which contain 3 columns: [Time Start], [Time End] and [Time Interval]. Time Interval is merely a combined reference to Time Start and Time End columns, like "6:00:00 AM-6:15:00 AM". I want to retrieve this Time Interval column to the DataExport table. My goal is to create a time range summary where I can see the the total number of orders in 15-minute intervals starting from 6:00:00 AM. I cannot merge these directly because the Time Range table only contains the Time start and Time end. For example, if the time is 6:01 AM then it belongs to the group 6:00 AM-6:15 AM and so on. Any ideas?

 

[AlienSx]

Any ideas?

- unpivot Time Start and Time End columns, values must be in column named Time
- combine this with DataExport table, sort by Time and fill down Time Interval column
- remove (filter out) rows from Time Range table.