Hi Charlotte,

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

But as soon the time of midnight (00:00) is involved, one way or
another, it goes wrong...

please test the formulas for case 2 and case 3. If something is wrong
with the formulas, please let me know.
Case 2 (23-00):
=IF(AND(A1<TIME(23,,),B1<A1,B10),TIME(1,,),IF(AND (A1<TIME(23,,),B1<TIME(23,59,59),B1TIME(23,,)),B1-TIME(23,,),IF(AND(A1TIME(23,,),B1A1,B1<TIME(23,5 9,59)),B1-A1,IF(AND(A1TIME(23,,),B1<A1),MOD(0-A1,1),0))))

Case 3 (00-03):
=IF(AND(B1TIME(3,,),A1B1),1/8,IF(AND(B1TIME(3,,),A1<B1),TIME(3,,)-A1,IF(AND(A1<TIME(3,,),B1<TIME(3,,),B1A1),B1-A1,IF(AND(B1<TIME(3,,),A1B1),B1,0))))


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