Spreadsheet: 153052d1335731332-excel-2007-dropdown-list-test
Sheet: Blank Off Duty

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | These columns will not print
 |  |  |  | Sun |  |  |  | Mon |  |  |  | [NAME] |  |  |  | Wed |  |  |  | Thurs |  |  |  | Fri |  |  |  | Sat
 |  | aa |  | D/O |  |  | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 18:00:00 |  | 17:00:00 | - | 22:00:00 |  | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 13:00:00 |  |  | D/O |  |  |  | Start times | Finish times | Reasons
 |  | bb |  | D/O |  |  | 08:00:00 | - | 18:00:00 |  |  | D/O |  |  | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 18:00:00 |  |  | D/O
 |  | cc |  | D/O |  |  | 08:00:00 | - | 13:00:00 |  | 08:00:00 | - | 13:00:00 |  | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 18:00:00 |  |  | D/O |  |  |  | 07:30:00 | 13:00:00 | R
 |  | dd | 12:30:00 | - | 22:00:00 | C |  | D/O |  |  |  | D/O |  |  |  | D/O |  |  | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 18:00:00 |  | 12:30:00 | - | 22:00:00 |  |  | 08:00:00 | 13:30:00 | C
 |  | ee | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 18:00:00 |  |  | D/O |  |  |  | D/O |  |  |  | D/O |  |  | 12:30:00 | - | 22:00:00 | C | 08:00:00 | - | 18:00:00 |  |  | 08:30:00 | 14:00:00 | -
 |  | ff |  | D/O |  |  |  | A/L |  |  |  | A/L |  |  |  | A/L |  |  |  | A/L |  |  |  | A/L |  |  |  | D/O |  |  |  | 09:00:00 | 14:07:00 | N
 |  | gg |  | D/O |  |  | 12:00:00 | - | 22:00:00 |  | 08:00:00 | - | 18:00:00 |  |  | D/O |  |  |  | D/O |  |  | 17:00:00 | - | 22:00:00 |  | 08:00:00 | - | 17:30:00 |  |  | 09:15:00 | 14:27:00 | C/R
 |  | hh |  | D/O |  |  | 08:00:00 | - | 18:00:00 |  |  | D/O |  |  | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 18:00:00 |  |  | D/O |  |  |  | 09:30:00 | 14:30:00 | MATY
 |  | ii |  | D/O |  |  | 08:00:00 | - | 13:00:00 |  | 08:00:00 | - | 13:00:00 |  | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 18:00:00 |  |  | D/O |  |  |  | 11:00:00 | 15:00:00 | UNION
 |  | jj | 12:30:00 | - | 22:00:00 | C |  | D/O |  |  |  | D/O |  |  |  | D/O |  |  | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 18:00:00 |  | 12:30:00 | - | 22:00:00 |  |  | 11:30:00 | 15:30:00 | APPRAISAL
 |  | kk | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 18:00:00 |  |  | D/O |  |  |  | D/O |  |  |  | D/O |  |  | 12:30:00 | - | 22:00:00 | C | 08:00:00 | - | 18:00:00 |  |  | 12:00:00 | 16:00:00 | MANDATORY
 |  | ll |  | D/O |  |  | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 18:00:00 |  | 17:00:00 | - | 22:00:00 |  | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 13:00:00 |  |  | D/O |  |  |  | 12:30:00 | 16:30:00 | D/O
 |  | [NAME] |  | D/O |  |  |  | A/L |  |  |  | A/L |  |  |  | A/L |  |  |  | A/L |  |  |  | A/L |  |  |  | D/O |  |  |  | 13:00:00 | 16:45:00 | A/L
 |  | nn |  | D/O |  |  | 08:00:00 | - | 18:00:00 |  |  | D/O |  |  | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 18:00:00 |  |  | D/O |  |  |  | 16:00:00 | 17:00:00 | SICK
 |  | oo |  | D/O |  |  | 08:00:00 | - | 13:00:00 |  | 08:00:00 | - | 13:00:00 |  | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 18:00:00 |  |  | D/O |  |  |  | 17:00:00 | 17:30:00 | T/am
 |  | pp | 12:30:00 | - | 22:00:00 | C |  | D/O |  |  |  | D/O |  |  |  | D/O |  |  | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 18:00:00 |  | 12:30:00 | - | 22:00:00 |  |  | T/am | 18:00:00 | T/pm
 |  | qq | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 18:00:00 |  |  | D/O |  |  |  | D/O |  |  |  | D/O |  |  | 12:30:00 | - | 22:00:00 | C | 08:00:00 | - | 18:00:00 |  |  | T/all day | 18:30:00 | T/all
 |  | rr |  | D/O |  |  | 08:00:00 | - | 13:00:00 |  | 08:00:00 | - | 13:00:00 |  | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 18:00:00 |  |  | D/O |  |  |  |  | 19:00:00
 |  | ss | 12:30:00 | - | 22:00:00 | C |  | D/O |  |  |  | D/O |  |  |  | D/O |  |  | 12:30:00 | - | 22:00:00 |  | 08:00:00 | - | 18:00:00 |  | 12:30:00 | - | 22:00:00 |  |  |  | 19:15:00
 |  | tt | 08:00:00 | - | 18:00:00 |  | 08:00:00 | - | 18:00:00 |  |  | D/O |  |  | 08:00:00 |  | 18:00:00 |  | 08:00:00 |  | 18:00:00 |  |  | - |  |  |  | D/O |  |  |  |  | 19:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T/pm