Hi guys,

Thanks to Arvi problem is solved now :)

Formula for basic time is:
=IF(B1<A1,1,MAX(8/24,B1))*24-MAX(8/24,A1)*24

And formula for overtime is:
=((B1<A1)*B1 + AND(B1A1,A1<8/24)*(MIN(8/24,B1)-A1))*24

Workes well so far !

Thanks to all who tried to help :-)

Regards,
Sasha


--
Sasha
------------------------------------------------------------------------
Sasha's Profile: http://www.excelforum.com/member.php...o&userid=36608
View this thread: http://www.excelforum.com/showthread...hreadid=563527