title: How to get start and end time of each shift
body: <p>I have a timeshift table, where 0 means no activity (or day off) and values &gt; 0 are different activities.</p>
  <p>I can find the start hour of the first shift and the end hour of the last shift, but i'm struggling to find the last hour of the first shift and the first hour of the second shift.. The table should look like this:</p>
  <p>EXCEL</p>
  <p><a href="https://i.stack.imgur.com/gsL7b.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gsL7b.png" alt="" /></a></p>
  <p>Taking in account the example above, what i exactly want is a formula to determine that:</p>
  <ul>
  <li>On row 3, the end of the first shift is column S (or 14:00) and the beginning of the second shift is column V (or 15:30)</li>
  <li>On row 6, the end of the first shift is column U (or 15:00) and the beginning of the second shift is column X (or 16:30), and so on...</li>
  </ul>