P
Pendelfin
Hi
I will try to put this as simply as I can for quite a complicated range of
data.
I am trying to prepare some information and flag anyone who has had over 4
calendar weeks absence from work.
Here is my problem.
I have multiple rows of data for each employee showing their absence.
Some absences will be showing as a lump amount ie 34 days. Some will be per
pay period so 28 days then the next 28 days so I need to add these 2
together. Finally some of these are recorded as individual days but it won't
show any data for weekends or bank holidays - therefore someone might have 45
rows of individual days.
Can anyone think of a way I can carry out any calcualtions on this? I have
tried various ideas but short of reviewing everyone individually - which
would probbaly take all year - I can't find a solution.
Many thanks for taking a look at this.
Victoria
I will try to put this as simply as I can for quite a complicated range of
data.
I am trying to prepare some information and flag anyone who has had over 4
calendar weeks absence from work.
Here is my problem.
I have multiple rows of data for each employee showing their absence.
Some absences will be showing as a lump amount ie 34 days. Some will be per
pay period so 28 days then the next 28 days so I need to add these 2
together. Finally some of these are recorded as individual days but it won't
show any data for weekends or bank holidays - therefore someone might have 45
rows of individual days.
Can anyone think of a way I can carry out any calcualtions on this? I have
tried various ideas but short of reviewing everyone individually - which
would probbaly take all year - I can't find a solution.
Many thanks for taking a look at this.
Victoria