Hi Charlotte,

Am Sat, 26 Jan 2013 14:46:12 +0100 schrieb Charlotte E.:

case 2 (23-00):
=MAX(,MIN(0+(TIME(23,,)0),B1+(A1B1))-MAX(TIME(23,,),A1))+MAX(,(MIN(0,B1+(A1B1))-A1)*(TIME(23,,)0))+MAX(,MIN(0+(TIME(23,,)0),B1+0 )-TIME(23,,))*(A1B1)

case 3 (00-03):
=MAX(,MIN(TIME(3,,)+(0TIME(3,,)),B1+(A1B1))-MAX(0,A1))+MAX(,(MIN(TIME(3,,),B1+(A1B1))-A1)*(0TIME(3,,)))+MAX(,MIN(TIME(3,,)+(0TIME(3,,) ),B1+0)-0)*(A1B1)



Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2