Calculating Schedule Time in Bins

[watdahek]

I have a large amount of schedule data that I am trying to bucket into half hour increments. I am looking for any assistance on the best way to do this. Here are the 4 important columns:

1) Segment Start Time (ex. 05/02/2015 12:33:00)
2) Segment End Time (ex. 05/02/2015 13:33:00)
3) Segment Duration - min (ex. 60)
4) Segment Code (ex. Paid Break)

[TABLE="width: 690"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]SEG_START_TIME[/TD]
[TD]SEG_END_TIME[/TD]
[TD]SEG_DURATION_MIN[/TD]
[TD]SEG_CODE_DESC[/TD]
[/TR]
[TR]
[TD]05/02/2015 12:33:00[/TD]
[TD]05/02/2015 13:33:00 PM[/TD]
[TD]60[/TD]
[TD]Paid Break 1[/TD]
[/TR]
</tbody>[/TABLE]

I am looking for a way to move this data into a pre-defined table so that I know how many minutes were worked in a specific code during each half hour increment. I suppose I could work this out with a very long IF formula but I am thinking there has to be a better way.

The output for the above record would look something like this:

[TABLE="width: 690"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD="align: right"]12:30[/TD]
[TD="align: right"]13:00[/TD]
[TD="align: right"]13:30[/TD]
[/TR]
[TR]
[TD]Paid Break[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]3
[/TD]
[/TR]
</tbody>[/TABLE]

Any help is greatly appreciated,
Steve