Ok...
It think i've done it!!

How realiable it is, i dunno... but it works

=MIN(10,((D7-B7+(D7<B7))*24-C7))
=MAX(0,((D12-B12+(D12<B12))*24-C12-10))


can anyone else confirm that this is ok to use?!


--
jongyrocka
------------------------------------------------------------------------
jongyrocka's Profile: http://www.excelforum.com/member.php...o&userid=27200
View this thread: http://www.excelforum.com/showthread...hreadid=467159