title: Excel VBA 2013 - Getting the start time and end time of the value
body: <p>I'm trying to get the Start Time and End Time of the same values and delete the entire row of it. </p>
  
  <pre><code>Name       Start time    End time
  Michael    2:57:00 PM   3:04:10 PM
  Michael    3:04:10 PM   3:12:29 PM
  Michael    3:12:29 PM   3:14:57 PM
  Sarah      3:19:53 PM   3:20:00 PM
  Sarah      3:20:00 PM   3:20:23 PM
  Michael    3:20:23 PM   3:23:49 PM
  </code></pre>
  
  <p>Output will be</p>
  
  <pre><code>Michael    2:57:00 PM   3:14:57 PM
  Sarah      3:19:53 PM   3:20:23 PM
  Michael    3:20:23 PM   3:23:49 PM
  </code></pre>
  
  <p>Sorry. I really don't know Macro. If someone can help me please. 
  It would much appreciated!</p>
  
  <p>Thanks!</p>
  
  <p>UPDATE:</p>
  
  <p>What I have is only deleting the duplicates. Which I think is not possible.</p>
  
  <pre><code>With ActiveSheet
      Set Rng = Range("A2", Range("B2").End(xlDown))
      Rng.RemoveDuplicates Columns:=Array(1, 2), Header:=xlYes
  End With
  </code></pre>