Attendance Occurrence Calculation in excel

Hi all! I run attendance reports on my associates and want to calculate a total number of occurrences over a given time and total number of hours missed.

I can of course do simple COUNTIF or adding up hours, but the consecutive is confusing me.

Items to note-

- The report generates the data for all employees at once, can be up to 20 or so, depending on team.

- The layout shows name and employee number, absence coding (unscheduled and unpaid unscheduled), date, amount of time missed

- it would need to count consecutive days as 1 occurrence (excluding weekends)

*bonus points if it can differentiate between consecutive full day absences or partial day absences. Consecutive partial day absences would count as individual occurrences, not a single one. A full workday is 8 hours.

Thank you!

EDIT- add example data from report

8/20 and 8/21 are consecutive full day absences, so would count as 1

12/19 and 12/22 are consecutive because we are excluding weekends, but NOT full day absences so would count as individual occurrences.

This person would then have 4 total occurrences.