Search a source sheet for date, employee email, and a checkbox and return the time
I am trying to build a clock-in/clock-out system. I have a form set up for my source sheet where employee can easily open the form, check the box for clock-in or clock-out and submit the form. From there, I want to pull that data into a time sheet for each employee... I am attempting to find a formula that will pull the time from the time column into the time sheet for that employee on the date and put the clock-in/clock-out times in their respective columns. I am thinking I need a nested IF formula as the source sheet is always growing. I'm having trouble and I'm not sure if it's my formula or that my source sheet is using system columns so I tried to do another column (32) where that information is just entered but it still didn't work. I'm not sure where to go from here. Screenshots of my source sheet and the time card sheet using my own information are attached.
Help Article Resources
Check out the Formula Handbook template!