title: Using Excel formula to find employee working times
body: <p>I have an Excel sheet with over 1,500 rows of data.  Each row tracks an employees start and stop time for a specific task and order number. I want to add up the total time for each person and/or location.</p>
  
  <p>I tried VLOOKUP to try and do this, but it just returns an error. For example, if I want to look for Karen's total work time, I would do something like VLOOKUP(Karen,F:F,9,TRUE).  What I get in return is an #REF!.  I suspect this has to do with there being something like 100 rows that are related to Karen's work and the VLOOKUP isn't going to add all the values found together.</p>
  
  <p>What I want is for the output, in one cell, to show the total time. I figured I might have to do something were it finds all of Karen's times and dumps them into a new column, and from there, I can sum them all up into a single cell to get the total time.</p>
  
  <p><a href="https://i.stack.imgur.com/erhoN.png" rel="nofollow noreferrer">Example of Excel document</a></p>