Two Time Ranges, Count and List of Hours That Overlap

[SanFelippo]

Hello,

I have two time ranges that are somewhere between 0-24 (this can loop around as well, such at a time that starts at 17 and ends at 6). I need to be able to have excel tell me what hours overlap between these time ranges, and also tell me the total number of hours that overlap. The data looks like what you see below. I would need whatever formula I put into the "Hours That Overlap" cells to spit out what you see filled out in them. Same goes for the "Total Hours that Overlap." Any help would be greatly appreciated!!

A Start Time	A End Time	B Start Time	B End Time	Hours That Overlap	Total Hours that Overlap
6	22	16	6	6-9, 16-22	11
12	22	15	8	15-22	8
9	18	15	4	15-18	4

<tbody>
</tbody>