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

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


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"bong" wrote in message
...

Dear all,

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


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

--
bong
------------------------------------------------------------------------
bong's Profile:
http://www.excelforum.com/member.php...o&userid=15087
View this thread: http://www.excelforum.com/showthread...hreadid=267228