title: Downtime calculation in excel
body: <p>I am trying to calculate downtime for devices. I would like to count only those time which is laying in a particular time slot. I am calling this time slot Min &amp; Max time. All the timestamp is with dates but when the date is changed time should calculate according to that. for one device I am able to do that but same formulas are not working for next device.</p>
  
  <p><strong>Logic: Timestamp is 22:00 and device the last timestamp was 6:00 hours before.
  And Min 6:00 AM to 18:00 PM</strong></p>
  
  <p>So the downtime would be <strong>2 hours</strong>. coz last time device communicated was 16:00 hours &amp; downtime consider at 18:00 hours. </p>
  
  <p><a href="https://drive.google.com/file/d/10zFAS1qfg5v56B3SP0XPU0ER3JCk8K1R/view?usp=sharing" rel="nofollow noreferrer">file</a></p>