I keep track of certain events in a spreadsheet, noting the time they occur and the person involved. This is for a small office bet, aiming to have the least total time and number of event triggers.

The concept is to note the person, the time the event occurred, and the time since the last change. With this information, I’ve created a summary table with the average time for each person, the minimum and maximum times, the total, and the number of event triggers.

However, there’s a problem: times are counted even outside of office hours. Consequently, some individuals are unhappy because they see their times counted during nights and weekends.

As a solution, I attempted to implement a counting system that only takes into account times between 8 am and 12 pm, then between 2 pm and 6 pm, but I was unsuccessful. Is it possible to perform such a calculation without resorting to a script? If so, could you please advise me on how to proceed?

Here’s a link to a test spreadsheet containing a few data points.

Thank you in advance for your assistance.