Spreadsheet: 219305d1362706103-calculating-how-many-hrs-are-ord-hrs-time-and-a-half-and-double-time-over-a-range-payroll-and-invoicing-wheatstone
Sheet: PAYROLL

WE [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCHEDULE OF HRS |  |  | 40 | 12 | 32
TEAM 1 |  |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  |  | SCHEDULE OF RATES |  | 7.18 | 38.98
SURNAME | FIRST NAME | [NAME] | 2013-02-24 00:00:00 | 2013-02-25 00:00:00 | 2013-02-26 00:00:00 | 2013-02-27 00:00:00 | 2013-02-28 00:00:00 | 2013-03-01 00:00:00 | 2013-03-02 00:00:00 | 2013-03-03 00:00:00 | 2013-03-04 00:00:00 | 2013-03-05 00:00:00 | 2013-03-06 00:00:00 | 2013-03-07 00:00:00 | 2013-03-08 00:00:00 | 2013-03-09 00:00:00 | FI | FO | Hrs Total | RDO | SITE ALLOWANCE | ORDINARY TIME | TIME AND HALF | DOUBLE TIME
CABRILOVSKI | GEORGE | [EMAIL] |  |  |  |  |  | FI | 12 | 12 | 12 | 12 | 7 | 12 | FI
HARWOOD | MARK | [EMAIL] |  |  |  |  |  | FI | 12
HERBERT | XAVIER | [EMAIL] |  |  |  |  |  | FI | 12
LORD | JAY | [EMAIL] |  |  |  |  |  | FI | 12
VAUGHAN | [NAME] | [EMAIL] |  |  |  |  |  | FI | 12
WAYRE | ADAM | [EMAIL] |  |  |  |  |  | FI | 12
MUIR | JAKE | [EMAIL] |  |  |  |  |  | FI | 12
COGAN | [NAME] | [EMAIL] |  |  |  |  |  | FI | 12
 |  |  |  | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 |  |  | 0.8 | 0.8 | 0.8 | 0.8 | 0.8
 |  |  |  |  |  |  |  |  | Accrued RDO |  |  |  |  |  |  | Accrued RDO
TEAM 2 |  |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  |  | SCHEDULE OFF RATES |  | 7.18 | 38.98
SURNAME | FIRST NAME | [NAME] | 2013-02-24 00:00:00 | 2013-02-25 00:00:00 | 2013-02-26 00:00:00 | 2013-02-27 00:00:00 | 2013-02-28 00:00:00 | 2013-03-01 00:00:00 | 2013-03-02 00:00:00 | 2013-03-03 00:00:00 | 2013-03-04 00:00:00 | 2013-03-05 00:00:00 | 2013-03-06 00:00:00 | 2013-03-07 00:00:00 | 2013-03-08 00:00:00 | 2013-03-09 00:00:00 | FLY IN | FLY OUT | Hrs Total |  | SITE ALLOWANCE | ORDINARY TIME | TIME AND HALF | DOUBLE TIME
HALL | JACK | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
PERKINS | IAN | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
KENNEDY | DARRREL | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TAYLOR | ADAM | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
WASS | CRAIG | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
HARNETT | CALLAN | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
KANIA | EDWARD | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
SHARP | [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  | 0.8 | 0.8 | 0.8 | 0.8 |  |  | 0 | 0.8 | 0.8 | 0.8 | 0.8
 |  |  |  |  |  |  |  |  | Accrued RDO |  |  |  |  |  |  | Accrued RDO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | if [NAME] is the number of hours worked then
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B1 = MIN(A1,8) is the hours of [NAME]
 |  |  |  |  |  |  |  |  |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  |  |  |  |  | C1 = MIN(A1-B1, 2) is the number of hours at time and 1/2
this is what weekly hrs should look like but |  | Double Time |  |  |  |  |  |  |  | 12 | 2 | 2 | 2 | 2 | 2 | 10 |  |  |  |  |  | D1 = MAX(A1-B1-C1,0) is the amount of double time
some of the conditions that may occur would |  | Time and Half |  |  |  |  |  |  |  | 0 | 2 | 2 | 2 | 2 | 2 | 2
be - if they did more than 12hrs (that would |  | Ordinary Hrs |  |  |  |  |  |  |  | 0 | 8 | 8 | 8 | 8 | 8 | 0
be Double time), and if they fly out that day.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF(C7="OFF",0,$D$5-C7+IF(D7>$E$5,D7-$E$5))