I am trying to use A Google Sheet generated by Google Forms to track total attendance time in lab for a robotics team. I have created a form with the following questions:
- Checking in or Checking out
- Check In Name
- Check Out Name
After selecting the first option, the respondent is directed to select their name from a pulldown list of all members. This generates a workbook similar to this workbook. The first sheet includes the responses with the timestamp which is important for recording times. I am thinking the second sheet (Hours) could be used to summarize time.
Is it possible to use a combination of IF and VLOOKUP to calculate hours per day? Or is there a more logical way to accomplish this?