Automatic change for time constraint

[bong]

Dear all,

I have asked some people to achieve my case which is specify in belo
file.
However, the overnight shift problem cannot be solved. See shift C1, a
it start at 19:30 and need pass through 00:00 which will increase th
value from 0 again.
Consider a period 00:00-00:15, the shift cover this period, it howeve
turn out is 0 which you can see in my file. Any loop can help to d
this?
Thank yo

+-------------------------------------------------------------------
|Filename: Shift.zip
|Download: http://www.excelforum.com/attachment.php?postid=2701
+-------------------------------------------------------------------

 

[Rob van Gelder]

I have a formula on my website: Hours affected by dates.
It'll handle dates spanning midnight.