Spreadsheet: 471005d1468836328-grouping-dates-into-instances-ignoring-weekends-sickness
Sheet: Sheet2

Day | Date | EmpCode | StartTime | Employee | FinishTime | DayCount | TotalHours | TotalHours | RemainingHours | AbsenceCode
Mon | 09/11/15 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 8:00 | 0:00 | S001  PAID SICKNESS
Tue | 10/11/15 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 16:00 | 0:00 | S001  PAID SICKNESS
Fri | 26/02/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 24:00 | 0:00 | S001  PAID SICKNESS
Mon | 29/02/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 32:00 | 0:00 | S001  PAID SICKNESS
Tue | 01/03/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 40:00 | 0:00 | S001  PAID SICKNESS
Wed | 02/03/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 48:00 | 0:00 | S001  PAID SICKNESS
Thu | 03/03/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 56:00 | 0:00 | S001  PAID SICKNESS
Fri | 04/03/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 64:00 | 0:00 | S001  PAID SICKNESS
Mon | 07/03/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 72:00 | 0:00 | S001  PAID SICKNESS
Tue | 08/03/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 80:00 | 0:00 | S001  PAID SICKNESS
Wed | 09/03/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 88:00 | 0:00 | S001  PAID SICKNESS
Thu | 10/03/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 96:00 | 0:00 | S001  PAID SICKNESS
Fri | 11/03/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 104:00 | 0:00 | S001  PAID SICKNESS
Mon | 14/03/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 112:00 | 0:00 | S001  PAID SICKNESS
Tue | 15/03/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 120:00 | 0:00 | S001  PAID SICKNESS
Wed | 16/03/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 128:00 | 0:00 | S001  PAID SICKNESS
Thu | 17/03/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 136:00 | 0:00 | S001  PAID SICKNESS
Fri | 18/03/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 144:00 | 0:00 | S001  PAID SICKNESS
Mon | 21/03/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 152:00 | 0:00 | S001  PAID SICKNESS
Tue | 22/03/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 160:00 | 0:00 | S001  PAID SICKNESS
Wed | 23/03/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 168:00 | 0:00 | S001  PAID SICKNESS
Thu | 24/03/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 176:00 | 0:00 | S001  PAID SICKNESS
Fri | 25/03/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 184:00 | 0:00 | S001  PAID SICKNESS
Mon | 28/03/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 192:00 | 0:00 | S001  PAID SICKNESS
Tue | 29/03/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 200:00 | 0:00 | S001  PAID SICKNESS
Wed | 30/03/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 208:00 | 0:00 | S001  PAID SICKNESS
Thu | 31/03/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 216:00 | 0:00 | S001  PAID SICKNESS
Fri | 01/04/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 224:00 | 0:00 | S001  PAID SICKNESS
Mon | 04/04/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 232:00 | 0:00 | S001  PAID SICKNESS
Tue | 05/04/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 240:00 | 0:00 | S001  PAID SICKNESS
Wed | 06/04/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 248:00 | 0:00 | S001  PAID SICKNESS
Thu | 07/04/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 256:00 | 0:00 | S001  PAID SICKNESS
Fri | 08/04/16 | 00716 | 9:00 | [NAME] | 17:00 | 1 | 8:00 | 264:00 | 0:00 | S001  PAID SICKNESS