title: Excel: track number of employees at a given moment
body: <p>I am trying to come up with an Excel sheet where I have a set of 30-minute intervals throughout the day (starting at 10:00 and ending at 20:00) and I would like to calculate how many employees are available during each of them.</p>
  
  <p>The data I have is their shift start/end and the start-end times of their lunch breaks (normally 1 hour, but for part-timers these last 30 minutes).</p>
  
  <p>Here's a sample file: <a href="http://www.mediafire.com/download/op3rarsiqj1sm77/time-tracker.xlsx" rel="nofollow">http://www.mediafire.com/download/op3rarsiqj1sm77/time-tracker.xlsx</a></p>
  
  <p>Do you have any suggestions?</p>
  
  <p>Thank you!</p>