I need to create an employee attendance spreadsheet. I pull the information from ACS and copy it into excel. I need to pull the first clock in per employee, per day and the last clock out per employee, per day. I would then like to have an "e/o" (early out), "L" (late) "A" (absent), etc, show in areas where necessary. Any help would be very appreciated. Please see attached.

Employee Attendance Help.xlsx