Spreadsheet: 132729d1323892721-calculate-hours-minutes-worked-formatting-hours-worked
Sheet: Sheet1

Date :- | 2011-09-23 00:00:00 |  | Machine :- | 7 |  | Shift :- | Days
Production
Operator | Clock no | Grade | In | Out | In | Out | Total Boxes | SMV | Pence per minute | Total Earnings | Machine | Shift | Basic Rate | Date
[NAME] | 1 | C | 06:00:00 | 14:00:00 |  |  | 1500 | 0.367 | 0.143745 | 79.1316225 | 7 | Days | 6.909000000000001 | 2011-09-23 00:00:00
[NAME] | 2 | A | 06:00:00 | 14:00:00 |  |  | 1500 | 0.367 | 0.179865 | 99.01568250000001 | 7 | Days | 6.909000000000001 | 2011-09-23 00:00:00
[NAME] | 3 | B | 06:00:00 | 14:00:00 |  |  | 1500 | 0.367 | 0.16758 | 92.25279 | 7 | Days | 6.909000000000001 | 2011-09-23 00:00:00
[NAME] | 4 | C | 06:00:00 | 14:00:00 |  |  | 1500 | 0.367 | 0.143745 | 79.1316225 | 7 | Days | 6.909000000000001 | 2011-09-23 00:00:00
[NAME] | 5 | A | 06:00:00 | 14:00:00 |  |  | 1500 | 0.367 | 0.179865 | 99.01568250000001 | 7 | Days | 6.909000000000001 | 2011-09-23 00:00:00
To work out total earnings = total pairs x SMV x pence per minute = daily wage
Time work
Operator | Clock no | Grade | In | Out | In | Out | Total Mins | Earnings
Pay average
Operator | Clock no | Grade | In | Out | In | Out | Total Mins | Earnings
Supervisor :- |  |  |  |  | Manager :-
THE OBJECTIVE IS TO RECORD THE TOTAL DAILY PAY PER EMPLOYEE BASED ON PIECEWORK, TIME WORK, AND AVERAGE PAY
IT IS NESSASARY TO BE ABLE TO CALCULATE THE TOTAL MINUITS WORKED IN THE TOP PART OF THE SHEET UNDER PRODUCTION
AS WELL AS TIME WORK (BASIC HOURLY PAY), AND PAY AVERAGE (ENHANCED HOURLY PAY)
IT WILL BE NESSASARY TO ACCOUNT FOR A TOTAL OF 420 MINUITES PER SHIFT ( 6AM TO 2PM, 8 HOURS, LESS 30 MIN BREAK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6-2 | 2-10 | Nights
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 0.1713 | 0.1713 | 0.179865
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | 0.1596 | 0.1596 | 0.16758
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | 0.1369 | 0.1369 | 0.143745
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0.54 | 0.54 | 0.54
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 0.367 | 0.367 | 0.367
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shift | Machine |  | 3 | 0.61 | 0.61 | 0.61
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0.367 | 0.367 | 0.367
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6-2 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2-10 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nights | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6-2 | 6.58
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2-10 | 6.58
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nights | 6.909000000000001