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


--
William DeLeo
------------------------------------------------------------------------
William DeLeo's Profile: http://www.excelforum.com/member.php...fo&userid=1256
View this thread: http://www.excelforum.com/showthread...hreadid=549150