title: Excel: Need a function to count if the given time interval exist within a specific time range...ignoring the given date
body: <p>I need an excel formula to count if the person still signed in within a time frame. For example:</p>
  
  <pre><code>Person  TimeIn              TimeOut
  1       6/22/2013 10:32 AM  6/22/2013 11:35 AM
  2       6/22/2013 10:36 AM  6/22/2013 12:52 PM
  3       6/23/2013 10:40 AM  6/23/2013 5:15 PM
  4       6/25/2013 12:42 PM  6/25/2013 1:25 PM
  5       6/25/2013 1:42 PM   6/25/2013 4:53 PM
  6       6/26/2013 3:30 PM   6/26/2013 5:00 PM
  </code></pre>
  
  <p><code>10:00AM - 12:00PM</code> The count should be <code>3</code>. Person 1 2 3 is signed in between those two time<BR>
  <code>12:00PM - 2:00PM</code> The count should be <code>4</code>. Person 2 3 4 5 is signed in between those two time<br>
  <code>2:00PM - 4:00PM</code> The count should be <code>3</code>. Person 3 5 6 is signed in between those two time<br>
  <code>4:00PM - 6:00PM</code> The count should be <code>3</code>. Person 3 5 6 is signed in between those two time<br><br>
  Basically if the person have not signed out, and is between those two time, i need a count ignoring the dates.</p>