Spreadsheet: 42541d1241086134-if-date-1-is-48hrs-before-date-2-return-1-test
Sheet: Test

 |  |  |  | Test | Company Name - Office_Name - Weekend 06 (02/05/09 - 03/05/09)
CLIENT |  |  |  |  |  | Test | WORKSITE | Somewhere
MRF |  |  |  |  |  | 12345 | ACCESS @ | Somewhere
REQUESTER |  |  |  |  |  | A N Other | DEPOT | Somewhere
QS |  |  |  |  |  |  | WORK DETAILS | Something
START |  |  | FINISH |  |  | Sat 2300 - Sun 1100
DAY | DATE | TIME | DAY | DATE | TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Shift Offered | PO Received | Cancelled On | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice | Ordered <48h | PO after shift | Cancelled <48h
Sat | 2009-05-02 00:00:00 | 2300 | Sun | 2009-04-03 00:00:00 | 1100 | COSS | [NAME] | [NAME] | 15 | 2009-04-29 00:00:00 | 2009-05-03 00:00:00 |  | 20 | LTD | OT2 | 12 | 180 | 240 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 1 |  | 1
 |  |  |  |  |  | SITE CONTACT: | Someone
CLIENT |  |  |  |  |  | Test | WORKSITE | Somewhere
MRF |  |  |  |  |  | 12345 | ACCESS @ | Somewhere
REQUESTER |  |  |  |  |  | A N Other | DEPOT | Somewhere
QS |  |  |  |  |  |  | WORK DETAILS | Something
START |  |  | FINISH |  |  | Sat 2300 - Sun 1100
DAY | DATE | TIME | DAY | DATE | TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Shift Offered | PO Received | Cancelled On | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice | Ordered <48h | PO after shift | Cancelled <48h
Sat | 2009-05-02 23:00:00 | 2300 | Sun | 2009-04-03 00:00:00 | 1100 | CANCELLED COSS | [NAME] | [NAME] | 15 | 2009-04-29 00:00:00 | 2009-05-02 05:00:00 | 2009-04-30 00:00:00 | 20 | LTD | OT2 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 1 |  | 1
 |  |  |  |  |  | SITE CONTACT: | Someone
CLIENT |  |  |  |  |  | Test | WORKSITE | Somewhere
MRF |  |  |  |  |  |  | ACCESS @ | Somewhere
REQUESTER |  |  |  |  |  |  | DEPOT | Somewhere
QS |  |  |  |  |  |  | WORK DETAILS | Something
START |  |  | FINISH
DAY | DATE | TIME | DAY | DATE | TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Shift Offered | PO Received | Cancelled On | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | SITE CONTACT:
CLIENT |  |  |  |  |  | Test | WORKSITE
MRF |  |  |  |  |  |  | ACCESS @
REQUESTER |  |  |  |  |  |  | DEPOT
QS |  |  |  |  |  |  | WORK DETAILS
START |  |  | FINISH
DAY | DATE | TIME | DAY | DATE | TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Shift Offered | PO Received | Cancelled On | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | SITE CONTACT:
CLIENT |  |  |  |  |  | Test | WORKSITE
MRF |  |  |  |  |  |  | ACCESS @
REQUESTER |  |  |  |  |  |  | DEPOT
QS |  |  |  |  |  |  | WORK DETAILS
START |  |  | FINISH
DAY | DATE | TIME | DAY | DATE | TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Shift Offered | PO Received | Cancelled On | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | SITE CONTACT:
CLIENT |  |  |  |  |  | Test | WORKSITE
MRF |  |  |  |  |  |  | ACCESS @
REQUESTER |  |  |  |  |  |  | DEPOT
QS |  |  |  |  |  |  | WORK DETAILS
START |  |  | FINISH
DAY | DATE | TIME | DAY | DATE | TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Shift Offered | PO Received | Cancelled On | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | SITE CONTACT:
CLIENT |  |  |  |  |  | Test | WORKSITE
MRF |  |  |  |  |  |  | ACCESS @
REQUESTER |  |  |  |  |  |  | DEPOT
QS |  |  |  |  |  |  | WORK DETAILS
START |  |  | FINISH
DAY | DATE | TIME | DAY | DATE | TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Shift Offered | PO Received | Cancelled On | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | SITE CONTACT:
CLIENT |  |  |  |  |  | Test | WORKSITE
MRF |  |  |  |  |  |  | ACCESS @
REQUESTER |  |  |  |  |  |  | DEPOT
QS |  |  |  |  |  |  | WORK DETAILS
START |  |  | FINISH
DAY | DATE | TIME | DAY | DATE | TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Shift Offered | PO Received | Cancelled On | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | SITE CONTACT:
CLIENT |  |  |  |  |  | Test | WORKSITE
MRF |  |  |  |  |  |  | ACCESS @
REQUESTER |  |  |  |  |  |  | DEPOT
QS |  |  |  |  |  |  | WORK DETAILS
START |  |  | FINISH
DAY | DATE | TIME | DAY | DATE | TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Shift Offered | PO Received | Cancelled On | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | SITE CONTACT:
CLIENT |  |  |  |  |  | Test | WORKSITE
MRF |  |  |  |  |  |  | ACCESS @
REQUESTER |  |  |  |  |  |  | DEPOT
QS |  |  |  |  |  |  | WORK DETAILS
START |  |  | FINISH
DAY | DATE | TIME | DAY | DATE | TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Shift Offered | PO Received | Cancelled On | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | SITE CONTACT:
CLIENT |  |  |  |  |  | Test | WORKSITE
MRF |  |  |  |  |  |  | ACCESS @
REQUESTER |  |  |  |  |  |  | DEPOT
QS |  |  |  |  |  |  | WORK DETAILS
START |  |  | FINISH
DAY | DATE | TIME | DAY | DATE | TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Shift Offered | PO Received | Cancelled On | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | SITE CONTACT:
CLIENT |  |  |  |  |  | Test | WORKSITE
MRF |  |  |  |  |  |  | ACCESS @
REQUESTER |  |  |  |  |  |  | DEPOT
QS |  |  |  |  |  |  | WORK DETAILS
START |  |  | FINISH
DAY | DATE | TIME | DAY | DATE | TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Shift Offered | PO Received | Cancelled On | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | SITE CONTACT: