Hi All

Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

Post Spam and you Will Be Deleted as a User

Hui...
When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula Challenge 025 - Calculation Interval Hours

Code:

=IF(AND((D$5-(D$5>D$6))<$B7,D$6>($A7-($A7>$B7))),MIN(D$6-(D$5>D$6),$B7)-MAX(D$5,$A7-($A7>$B7)),0)

Top