Need to identify the number of minutes that fit into a specific interval

Hi,

I am trying to determine the number of active minutes that happen during specified half hour increments of time. I have a large list of occurances with a start time in one column and an end time in another column. I want to easily identify the number of minutes from that occurance that fits each range. I eventually want to be able to sum the values in each range of time, but plan on doing that in a pivot table.

Here is a sample of how I have things set up currently, I filled in the first line manually to try and display what I'm trying to accomplish.

Capacity_Test.xlsx

Does anyone know of a way to do this using a formula? I tried a couple of IF statements, but don't have a lot of experience with them and kept getting errors.

If anyone has a completely different way of doing this, I'm open to suggestions.

Thanks much!
Tammy

Worked like a charm. You are a life saver, thanks much!