I have a source table with these columns:

![enter image description here](https://i.stack.imgur.com/JVIWt.png)

I also have a destination table like this:

![enter image description here](https://i.stack.imgur.com/C1tC2.png)

The destination table has 1440 rows, with the minute column filled in (1 row for each minute in the day).

For each row in the source table, I need to fill in a "1" in the destination table for the appropriate channel (there are 10 channels total), for every minute between the StartTime and FinishTime.

I'm just doing this in MySQL Workbench (it's a one-time query). What is my beast approach?

Thanks,

-Scott