W
William DeLeo
Greetings,
My brain hurts. I need some eloquent way of evaluating if one tim
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 t
determine how much overlap exists. The answer that I need for th
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 kno
there is a better way. Can anyone offer a suggestion?
TIA
Bill
My brain hurts. I need some eloquent way of evaluating if one tim
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 t
determine how much overlap exists. The answer that I need for th
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 kno
there is a better way. Can anyone offer a suggestion?
TIA
Bill