Absence Periods Calculation

Originally Posted by humdingaling

dele...dont usually proceed with anything if people stop responding
it usually means they figured it out and plain moved on

also as i really don't know exactly what you want i didnt know how to proceed

i added some lines and a table to your original sheet
please indicate the lines you want skipped?

6 and 7 = Saturday and Sunday respectively

Hi, understood, got completely caught in something else. Yes lines 6 and 7 need to be ignored with both 1 and 5 linked to form one period. For example, staff member 439 should have 3 periods not 5 (2 really because there are 2 bank holidays but ignore, i dont want to over complicate) Thanks again