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

Ignore this request - I tried posting it on the UK forum and it appeared here
lol

Please see 2nd request Calcualting Number of Days on Multiple Rows

Apologies

Pen
"Pendelfin" wrote:

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