Spreadsheet: 43958d1242643381-returning-a-value-if-the-dates-times-in-two-cells-are-between-x-amount-of-hours-test-1
Sheet: Sheet01

Test Planner
DELIVERY UNIT: |  | Test Planner | WORKSITE:
REQ NO: |  |  | SITE ACCESS:
JOB NO: |  |  | WORK DETAILS:
PROJECT CODE: |  |  | WORK ID NO
COST CENTRE: |  |  | REQUESTER
PURCHASE ORDER NO: |  |  | QS
START | FINISH | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | [NAME] | PO Received | Cancelled | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice | Requested <48h Notice | PO Received After Shift | Cancelled <48h Notice
2009-05-18 12:00:00 |  |  |  |  |  |  |  | 2009-05-18 09:00:00 |  |  |  |  | 0 | 0 |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | SITE CONTACT:
DELIVERY UNIT: |  | Test Planner | WORKSITE:
REQ NO: |  |  | SITE ACCESS:
JOB NO: |  |  | WORK DETAILS:
PROJECT CODE: |  |  | WORK ID NO
COST CENTRE: |  |  | REQUESTER
PURCHASE ORDER NO: |  |  | QS
START | FINISH | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | [NAME] | PO Received | Cancelled | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice | Requested <48h Notice | PO Received After Shift | Cancelled <48h Notice
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | SITE CONTACT:
DELIVERY UNIT: |  | Test Planner | WORKSITE:
REQ NO: |  |  | SITE ACCESS:
JOB NO: |  |  | WORK DETAILS:
PROJECT CODE: |  |  | WORK ID NO
COST CENTRE: |  |  | REQUESTER
PURCHASE ORDER NO: |  |  | QS
START | FINISH | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | [NAME] | PO Received | Cancelled | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice | Requested <48h Notice | PO Received After Shift | Cancelled <48h Notice
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | SITE CONTACT:
DELIVERY UNIT: |  | Test Planner | WORKSITE:
REQ NO: |  |  | SITE ACCESS:
JOB NO: |  |  | WORK DETAILS:
PROJECT CODE: |  |  | WORK ID NO
COST CENTRE: |  |  | REQUESTER
PURCHASE ORDER NO: |  |  | QS
START | FINISH | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | [NAME] | PO Received | Cancelled | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice | Requested <48h Notice | PO Received After Shift | Cancelled <48h Notice
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | SITE CONTACT:
DELIVERY UNIT: |  | Test Planner | WORKSITE:
REQ NO: |  |  | SITE ACCESS:
JOB NO: |  |  | WORK DETAILS:
PROJECT CODE: |  |  | WORK ID NO
COST CENTRE: |  |  | REQUESTER
PURCHASE ORDER NO: |  |  | QS
START | FINISH | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | [NAME] | PO Received | Cancelled | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice | Requested <48h Notice | PO Received After Shift | Cancelled <48h Notice
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | SITE CONTACT:
DELIVERY UNIT: |  | Test Planner | WORKSITE:
REQ NO: |  |  | SITE ACCESS:
JOB NO: |  |  | WORK DETAILS:
PROJECT CODE: |  |  | WORK ID NO
COST CENTRE: |  |  | REQUESTER
PURCHASE ORDER NO: |  |  | QS
START | FINISH | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | [NAME] | PO Received | Cancelled | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice | Requested <48h Notice | PO Received After Shift | Cancelled <48h Notice
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | SITE CONTACT:
DELIVERY UNIT: |  | Test Planner | WORKSITE:
REQ NO: |  |  | SITE ACCESS:
JOB NO: |  |  | WORK DETAILS:
PROJECT CODE: |  |  | WORK ID NO
COST CENTRE: |  |  | REQUESTER
PURCHASE ORDER NO: |  |  | QS
START | FINISH | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | [NAME] | PO Received | Cancelled | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice | Requested <48h Notice | PO Received After Shift | Cancelled <48h Notice
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | SITE CONTACT:
DELIVERY UNIT: |  | Test Planner | WORKSITE:
REQ NO: |  |  | SITE ACCESS:
JOB NO: |  |  | WORK DETAILS:
PROJECT CODE: |  |  | WORK ID NO
COST CENTRE: |  |  | REQUESTER
PURCHASE ORDER NO: |  |  | QS
START | FINISH | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | [NAME] | PO Received | Cancelled | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice | Requested <48h Notice | PO Received After Shift | Cancelled <48h Notice
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | SITE CONTACT:
DELIVERY UNIT: |  | Test Planner | WORKSITE:
REQ NO: |  |  | SITE ACCESS:
JOB NO: |  |  | WORK DETAILS:
PROJECT CODE: |  |  | WORK ID NO
COST CENTRE: |  |  | REQUESTER
PURCHASE ORDER NO: |  |  | QS
START | FINISH | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | [NAME] | PO Received | Cancelled | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice | Requested <48h Notice | PO Received After Shift | Cancelled <48h Notice
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | SITE CONTACT:
DELIVERY UNIT: |  | Test Planner | WORKSITE:
REQ NO: |  |  | SITE ACCESS:
JOB NO: |  |  | WORK DETAILS:
PROJECT CODE: |  |  | WORK ID NO
COST CENTRE: |  |  | REQUESTER
PURCHASE ORDER NO: |  |  | QS
START | FINISH | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | [NAME] | PO Received | Cancelled | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice | Requested <48h Notice | PO Received After Shift | Cancelled <48h Notice
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | SITE CONTACT:
DELIVERY UNIT: |  | Test Planner | WORKSITE:
REQ NO: |  |  | SITE ACCESS:
JOB NO: |  |  | WORK DETAILS:
PROJECT CODE: |  |  | WORK ID NO
COST CENTRE: |  |  | REQUESTER
PURCHASE ORDER NO: |  |  | QS
START | FINISH | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | [NAME] | PO Received | Cancelled | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice | Requested <48h Notice | PO Received After Shift | Cancelled <48h Notice
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | SITE CONTACT:
DELIVERY UNIT: |  | Test Planner | WORKSITE:
REQ NO: |  |  | SITE ACCESS:
JOB NO: |  |  | WORK DETAILS:
PROJECT CODE: |  |  | WORK ID NO
COST CENTRE: |  |  | REQUESTER
PURCHASE ORDER NO: |  |  | QS
START | FINISH | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | [NAME] | PO Received | Cancelled | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice | Requested <48h Notice | PO Received After Shift | Cancelled <48h Notice
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | SITE CONTACT:
DELIVERY UNIT: |  | Test Planner | WORKSITE:
REQ NO: |  |  | SITE ACCESS:
JOB NO: |  |  | WORK DETAILS:
PROJECT CODE: |  |  | WORK ID NO
COST CENTRE: |  |  | REQUESTER
PURCHASE ORDER NO: |  |  | QS
START | FINISH | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | [NAME] | PO Received | Cancelled | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice | Requested <48h Notice | PO Received After Shift | Cancelled <48h Notice
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | SITE CONTACT:
DELIVERY UNIT: |  | Test Planner | WORKSITE:
REQ NO: |  |  | SITE ACCESS:
JOB NO: |  |  | WORK DETAILS:
PROJECT CODE: |  |  | WORK ID NO
COST CENTRE: |  |  | REQUESTER
PURCHASE ORDER NO: |  |  | QS
START | FINISH | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | [NAME] | PO Received | Cancelled | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice | Requested <48h Notice | PO Received After Shift | Cancelled <48h Notice
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | SITE CONTACT:
DELIVERY UNIT: |  | Test Planner | WORKSITE:
REQ NO: |  |  | SITE ACCESS:
JOB NO: |  |  | WORK DETAILS:
PROJECT CODE: |  |  | WORK ID NO
COST CENTRE: |  |  | REQUESTER
PURCHASE ORDER NO: |  |  | QS
START | FINISH | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | [NAME] | PO Received | Cancelled | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice | Requested <48h Notice | PO Received After Shift | Cancelled <48h Notice
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | SITE CONTACT: