Hi San,

Am Sat, 16 Mar 2013 03:58:12 -0700 (PDT) schrieb shriil:

=IF(INT(B1)=INT(A1),(MIN(11/12,MOD(B1,1))-MAX(5/24,MOD(A1,1)))*24,(B1-A1)*24-(INT(B1)-INT(A1))*7)

without IF-statement:
=(MIN(MAX(B2,INT(B2)+5/24),INT(B2)+11/12)-MIN(MAX(A2,INT(A2)+5/24),INT(A2)+11/12))*24-(INT(B2)-INT(A2))*7


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