Greetings,

My brain hurts. I need some eloquent way of evaluating if one time range (given in two cells as start and end time) overlaps with another, and if so by how much time. I'll explain ...

I will have a time range as input, say start time = 2:37 and end time = 4:20. For each hour in the day (e.g. 1-2, 2-3, 3-4, etc) I need to determine how much overlap exists. The answer that I need for the period above would be:

time period 1-2 => 0%
time period 2-3 => (37/60)%
time period 3-4 => 100%
time period 4-6 => (20/60)%
time period 5-6 => 0%

All my ideas simply have too many embedded conditionals and I know there is a better way. Can anyone offer a suggestion?

TIA
Billy