I am looking for a way to determine if an employee took their required 30 min break after working a minimum of 6 hours during their shift. The problem is that our Time and attendance software generated a basic report and separates a shift into multiple rows. the only unique identifier is the "timesheet_id" column. and the only way of telling that a specific row refers to a beak is if the b_break columns value is true. What I need to know is if the employee worked over 6 hours and did not take a break at all.

Is there a way to consolidate based on this timesheet_id and then apply formula to figure this out ? payroll detail.png