Trying to create a Duty Cycle graph.

Hi All;

I'm new here, so I will try to detail my issue as much as I can.
Creating the graph itself is a non-issue, it's the data format I need in order for the graph to display what I want properly.
Here is what I need:
In column A is a block of time (from 12:00:00 - 12:59:59 for example) incrementing by 3 seconds per cell. This will be my x-axis. I have a series of start and stop times listed. Start times are in column D, stop times are in column E.
In order to show on/off time with duration I need to assign a value of 0 or 1 in the corresponding cells in column B. All the times that fall between the start and stop times listed in columns D & E will be assigned a 1, and all other times will be assigned a 0.
I can do this for a single start/stop time using a nested IF statement, but I need to be able to assign 1's for all start/stop ranges listed to column B.
With the data formatted like this the graph should show a square wave that depicts all the start/stop events within the time block I have selected. I could do this manually, but I have way too much data and it would take weeks.
I have attached a couple of screencaps of the format I'm talking about.
Any help would be appreciated as I'm really scratching my head on this.