Spreadsheet: 134796d1325633101-colour-coding-cells-if-contracted-hours-not-met-test-sheet
Sheet: PFS

Date :- | 2012-01-02 00:00:00 |  |  | Machine :- | 1 |  | Shift :- | 6-2
Production
Clock no | Operator | Grade |  | In | Out | In | Out | Total Pairs | SMV | Pence per minute | Timework Minuits | Pay Average | Piecework Earnings | Timework Earnings | Pay Average Earnings | Total  Daily Earnings | Machine | Shift | Basic Rate | Date |  |  | Piecework Minuites | Timework Minuits | Pay Average | Total Minuites | ContractedMinuites | [NAME]  (+OT / -Under)
 | ATLEY A |  |  | 06:00:00 | 14:00:00 |  |  | 1250 |  |  | 30 | 0
 | BENTLY B |  |  | 06:00:00 | 13:00:00 |  |  |  |  |  | 0 | 0
 | COLE C |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | DAVIS D |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | [NAME] |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | [NAME] |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | GREEN G |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | HOMER H |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | IBBOT I |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | [NAME] |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
Date :- | 2012-01-02 00:00:00 |  |  | Machine :- | 1 |  | Shift :- | 2-10
Production
Clock no | Operator | Grade |  | In | Out | In | Out | Total Pairs | SMV | Pence per minute | Timework Minuits | Pay Average | Piecework Earnings | Timework Earnings | Pay Average Earnings | Total  Daily Earnings | Machine | Shift | Basic Rate | Date |  |  | Piecework Minuites | Timework Minuits | Pay Average | Total Minuites | ContractedMinuites | [NAME]  (+OT / -Under)
 | ATLEY A |  |  | 06:00:00 | 14:00:00 |  |  | 1250 |  |  | 0 | 0
 | BENTLY B |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | COLE C |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | DAVIS D |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | [NAME] |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | [NAME] |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | GREEN G |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | HOMER H |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | IBBOT I |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | [NAME] |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
Date :- | 2012-01-02 00:00:00 |  |  | Machine :- | 2 |  | Shift :- | 6-2
Production
Clock no | Operator | Grade |  | In | Out | In | Out | Total Pairs | SMV | Pence per minute | Timework Minuits | Pay Average | Piecework Earnings | Timework Earnings | Pay Average Earnings | Total  Daily Earnings | Machine | Shift | Basic Rate | Date |  |  | Piecework Minuites | Timework Minuits | Pay Average | Total Minuites | ContractedMinuites | [NAME]  (+OT / -Under)
 | ATLEY A |  |  | 06:00:00 | 14:00:00 |  |  | 1250 |  |  | 0 | 0
 | BENTLY B |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | COLE C |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | DAVIS D |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | [NAME] |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | [NAME] |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | GREEN G |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | HOMER H |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | IBBOT I |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | [NAME] |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
Date :- | 2012-01-02 00:00:00 |  |  | Machine :- | 2 |  | Shift :- | 2-10
Production
Clock no | Operator | Grade |  | In | Out | In | Out | Total Pairs | SMV | Pence per minute | Timework Minuits | Pay Average | Piecework Earnings | Timework Earnings | Pay Average Earnings | Total  Daily Earnings | Machine | Shift | Basic Rate | Date |  |  | Piecework Minuites | Timework Minuits | Pay Average | Total Minuites | ContractedMinuites | [NAME]  (+OT / -Under)
 | ATLEY A |  |  | 06:00:00 | 14:00:00 |  |  | 1250 |  |  | 0 | 0
 | BENTLY B |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | COLE C |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | DAVIS D |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | [NAME] |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | [NAME] |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | GREEN G |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | HOMER H |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | IBBOT I |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | [NAME] |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
Date :- | 2012-01-02 00:00:00 |  |  | Machine :- | 3 |  | Shift :- | Days
Production
Clock no | Operator | Grade |  | In | Out | In | Out | Total Pairs | SMV | Pence per minute | Timework Minuits | Pay Average | Piecework Earnings | Timework Earnings | Pay Average Earnings | Total  Daily Earnings | Machine | Shift | Basic Rate | Date |  |  | Piecework Minuites | Timework Minuits | Pay Average | Total Minuites | ContractedMinuites | [NAME]  (+OT / -Under)
 | ATLEY A |  |  | 06:00:00 | 14:00:00 |  |  | 1250 |  |  | 0 | 0
 | BENTLY B |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | COLE C |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | DAVIS D |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | [NAME] |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | [NAME] |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | GREEN G |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | HOMER H |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | IBBOT I |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 | [NAME] |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0