Reply to thread

Message: [QUOTE="Rob van Gelder, post: 3415375"] Indeed. Perhaps Jan, you are not receiving all of the posts? The formula which I recommended works fine, with a little modification. The original formula is in the "Hours affected by Dates" page of my website. Here's the modification that fits your problem. Just put 00:00 in D6, =D6+1/24 in D7 This formula (no spaces) goes in C6. =IF(OR(AND(C$1<=C$2,C$2<=D6),AND(C$1>=E6,OR(C$1<=C$2,C$2<=D6))),0,IF(AND(C$2 <=E6,C$2>=D6,OR(C$1<=D6,C$1>=E6)),C$2-D6,IF(OR(AND(C$1<=D6,C$2>=E6),AND(C$1> =C$2,OR(C$1<=D6,C$2>=E6))),E6-D6,IF(AND(C$1<=C$2,C$1>=D6,C$2<=E6),C$2-C$1,IF (AND(C$1>=D6,C$1<=E6,OR(C$2<=D6,C$2>=E6)),E6-C$1,(C$2-D6)+(E6-C$1)))))) Then fill down the formula. It's overkill (because it handles ranges over midnight), but should do what you're after. [/QUOTE]