using start time and end time to calculate durations by hour

[tthomas via AccessMonster.com]

Greetings,
I have a table that contains events that have a start date/time and end
date/time. I would like to calculate durations broken out by hour.
So
12:00:00 - 12:59:59 am - summed number of minutes that occured during that
time range
01:00:00 - 01:59:59 am - summed number of minutes that occured during that
time range
etc..

I have some ideas on how to brute force through this, but knowing the amazing
minds out here, figure that someone has figured out an elegant solution...
Thanks,
Teresa