Excel overtime management

Hello,

I have also done this kind of thing in the past.

It seems difficult to propose a "universal" model because we need to know whether the table concerns a single employee or all employees of a company and we must take into account the specifics of the collective agreement (thresholds and rates for overtime, potential evening, night, public holiday work, absences...).

In any case, the principle is always the same: establish a typical schedule for each employee, which can become more complex if everyone has different standard weeks due to shifts, enter the actual hours into another sheet and compare; there aren't any particular difficulties, just a bit of calculation to consider these various factors.

In my opinion, we will only be able to do this optimally if we have a fictitious file showing this organization.