Spreadsheet: 105490d1302815835-how-to-work-out-a-time-formula-to-ignore-certain-information-register-v2
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 | 1 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  |  |  |  |  |  | FRI | 1 | 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 | 1 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 1 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  |  |  |  |  |  | FRI | 1 | 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 | 1 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 1 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  |  |  |  |  |  | FRI | 1 | 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 | 1 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 1 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  |  |  |  |  |  | FRI | 1 | 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 | 1 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 1 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  |  |  |  |  |  | FRI | 1 | 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 | 1 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 1 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  |  |  |  |  |  | FRI | 1 | 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 | 1 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 1 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  |  |  |  |  |  | FRI | 1 | 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 | 1 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 1 | 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 | 1 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 1 | 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 | 1 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 1 | 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 | 1 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 1 | 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 | 1 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00 |  |  |  | FRI | 1 | 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