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
+-------------------------------------------------------------------

--
bon
-----------------------------------------------------------------------
bong's Profile: http://www.excelforum.com/member.php...fo&userid=1508
View this thread: http://www.excelforum.com/showthread.php?threadid=26722