Hi there,

I've looked on the web but I still cannot find a clear answer to my query so hope you can assist.

To summarise; I work in an organisation that includes shift workers (24/7) and office workers (9-5). Sickness absence rate is recorded in hours or days OR both (which never helps) and isn't always recorded correctly.

As a result, week days between the start and end dates are used (think Networkdays on Excel). Any absences solely on the weekend for the shift workers is calculated using the evidence they have provided and some assumption.

The issue I am having isn't the above, the issue I am having is how to calculate sickness for part-time workers.

The general consensus is working days lost over days available. What isn't clear is whether the above figure is pro-rate to their FTE (shift workers do not work consistent hours each day so calculating hours lost isn't possible.)

Example; Staff A works 3.5 days in the week and is off all of these days. Actual working days available to them is 3.5 although they are off for 4 days (we do not calculate sickness in half days but whole days). This would suggest 4/3.5 which gives us more than a 100% absence rate in that week.

Another method suggested (for all staff) is Total days sickness (full days) / Total working days available (FTE) to anyone who worked in that period.

I may be over complicating this as however it would be good to get some thoughts please.

Apologies for the long opening post.

Thank you