Spreadsheet: 105504d1302820227-how-to-work-out-a-time-formula-to-ignore-certain-information-dmnortheastmonth
Sheet: Daily Register

DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS |  | DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS |  | DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS
FRI | 1 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 13 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 25 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00
 |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00 |  |  |  |  |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00 |  |  |  |  |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00
 |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00 |  |  |  |  |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00 |  |  |  |  |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00
 |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00 |  |  |  |  |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00 |  |  |  |  |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00
 |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00 |  |  |  |  |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00 |  |  |  |  |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00
DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS |  | DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS |  | DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS
FRI | 2 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 14 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 26 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00
 |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00 |  |  |  |  |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00 |  |  |  |  |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00
 |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00 |  |  |  |  |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00 |  |  |  |  |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00
 |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00 |  |  |  |  |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00 |  |  |  |  |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00
 |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00 |  |  |  |  |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00 |  |  |  |  |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00
DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS |  | DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS |  | DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS
FRI | 3 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 15 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 27 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00
 |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00 |  |  |  |  |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00 |  |  |  |  |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00
 |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00 |  |  |  |  |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00 |  |  |  |  |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00
 |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00 |  |  |  |  |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00 |  |  |  |  |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00
 |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00 |  |  |  |  |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00 |  |  |  |  |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00
DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS |  | DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS |  | DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS
FRI | 4 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 16 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 28 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00
 |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00 |  |  |  |  |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00 |  |  |  |  |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00
 |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00 |  |  |  |  |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00 |  |  |  |  |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00
 |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00 |  |  |  |  |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00 |  |  |  |  |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00
 |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00 |  |  |  |  |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00 |  |  |  |  |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00
DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS |  | DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS |  | DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS
FRI | 5 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 17 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 29 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00
 |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00 |  |  |  |  |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00 |  |  |  |  |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00
 |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00 |  |  |  |  |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00 |  |  |  |  |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00
 |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00 |  |  |  |  |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00 |  |  |  |  |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00
 |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00 |  |  |  |  |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00 |  |  |  |  |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00
DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS |  | DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS |  | DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS
FRI | 6 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 18 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 30 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00
 |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00 |  |  |  |  |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00 |  |  |  |  |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00
 |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00 |  |  |  |  |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00 |  |  |  |  |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00
 |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00 |  |  |  |  |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00 |  |  |  |  |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00
 |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00 |  |  |  |  |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00 |  |  |  |  |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00
DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS |  | DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS |  | DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS
FRI | 7 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 19 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 31 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00
 |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00 |  |  |  |  |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00 |  |  |  |  |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00
 |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00 |  |  |  |  |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00 |  |  |  |  |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00
 |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00 |  |  |  |  |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00 |  |  |  |  |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00
 |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00 |  |  |  |  |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00 |  |  |  |  |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00
DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS |  | DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS
FRI | 8 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 20 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00
 |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00 |  |  |  |  |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00
 |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00 |  |  |  |  |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00
 |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00 |  |  |  |  |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00
 |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00 |  |  |  |  |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00
DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS |  | DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS
FRI | 9 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 21 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00
 |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00 |  |  |  |  |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00
 |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00 |  |  |  |  |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00
 |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00 |  |  |  |  |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00
 |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00 |  |  |  |  |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00
DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS |  | DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS
FRI | 10 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 22 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00
 |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00 |  |  |  |  |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00
 |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00 |  |  |  |  |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00
 |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00 |  |  |  |  |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00
 |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00 |  |  |  |  |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00
DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS |  | DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS
FRI | 11 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 23 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00
 |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00 |  |  |  |  |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00
 |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00 |  |  |  |  |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00
 |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00 |  |  |  |  |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00
 |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00 |  |  |  |  |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00
DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS |  | DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS
FRI | 12 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 24 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00
 |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00 |  |  |  |  |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:45:00
 |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00 |  |  |  |  |  | C.PERSON | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00
 |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00 |  |  |  |  |  | D.PERSON | 08:00:00 | 10:00:00 | 14:30:00 | 17:30:00
 |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00 |  |  |  |  |  | E.PERSON | 10:45:00 | 11:45:00 | 13:00:00 | 14:00:00