title: How can I solve Working Time Calculation Problem in VBA
body: <p>I have a list which consists of different students' check-in check-out dates and times like below:</p>
  <p><a href="https://i.stack.imgur.com/Dy0zQ.png" rel="nofollow noreferrer">![enter image description here</a></p>
  <p>My friend wrote a code to calculate work hour of each students per day. Program prints day count, dates and work hour of working more than 11 hours and less than 7 hours.</p>
  <p>You can see the result page here:</p>
  <p><a href="https://i.stack.imgur.com/q429a.png" rel="nofollow noreferrer">enter image description here</a></p>
  <p>I have to write a program which calculates work hour per day for each student. Problem is that students check in and out multiple times in a day so I have to sum this in and outs for each day.</p>