Hi I have been asked to do some complex analysis on absence management. The problem is our HR System reports absence by each week. So for example someone who has been off for 5 weeks will have 5 different records, but these are continuous (eg.1st record starts on Monday and finishes Sunday...