Spreadsheet: 835155d1688375714-if-formula-to-calculate-work-hours-in-span-hours-template-1-
Sheet: Sheet1

CHARLES DARWIN UNIVERSITY CASUAL EMPLOYEE REMEDIATION - PROFESSIONAL
Employee Details |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fortnightly Pay Adjustment Summary
Emp. ID: |  | FYR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Paid | Due | Difference
Surname: |  | Pay |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross Adjustment | 2450.61
First Name(s): |  | Faculty/Division: | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Superannuation | 100 | Refer to FYR summary for superannuation calculation
[NAME]: | 50 | School/Branch: | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Superannuation Rate for FYR | 0.1
Meal Allowance Rate: | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Superannuatiom OTE
Payday | 00:00:00
Fortnight Start Date: | 00:00:00
PROFESSIONAL EMPLOYEES - RECALCUATIOED FORTNIGHTLY PAY
Day | Date | Public Holiday | Job | #Position | Professional Employee Level | Hrly rate of pay (inc 25% [NAME]) | Work type | Use 24 hour time fomat for start & finish times below (HH:MM) |  |  |  | Hours Claimed | Cumlative Hours per day (H) | [NAME] (Decimal) | Salary $ per job | Overtime hours | Overtime - Time and a Half. |  | Overtime - Double Time. |  | Overtime - Double Time and a half. |  | Overtime Daily $ Total |  | Penalty for work outside span (ie within 7.35 per day but outside span)  Monday to Sat |  | Penalty for work outside span (ie within 7.35 per day but outside span)  Sunday |  | Penalty for work outside span (ie within 7.35 per day but outside span)  Public Holiday |  | Daily summary # of normal hrs to be paid as [NAME] | Daily Summary of  Salary $ | Daily # of overtime hrs to be paid | Daily Summary of Overtime $ | Daily # of  Penalty hrs to be paid | Daily Summary of Penalty $ | Meal Allowances | Meal $ | Gross amount | Were you on campus for study or other CDU paid work on this day?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (Normal + 50%) |  | (Normal + 100%) |  | (Normal + 150%) |  |  |  | 150% (100% Salary) |  | 200% (100% Salary) |  | 2.5
 |  |  |  |  |  |  |  | Start | Finish | Start | Finish |  |  |  |  |  | 1.5 |  | 2 |  | 2.5 |  |  | Total hours work in span hrs | 0.5 |  | 1 |  | 1.5
Thursday |  |  |  |  | Professional - 1.3 | 50 | Normal hours | 06:00:00 | 12:00:00 | 13:00:00 | 13:21:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | No
 |  |  |  |  | Professional - 1.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 1.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 1.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 1.3 |  | Recalled to duty OT |  |  |  |  |  |  | N/A | N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Friday |  |  |  |  | Professional - 1.3 |  | Normal hours | 08:00:00 | 10:00:00 | 11:30:00 | 17:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 1.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 1.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 1.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 1.3 |  | Recalled to duty OT |  |  |  |  |  |  | N/A | N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Saturday |  |  |  |  | Professional - 2.3 |  | Recalled to duty OT | 08:00:00 | 10:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A | N/A |  |  |  |  | N/A | N/A |  | No
Sunday |  |  |  |  | Professional - 2.3 |  | Recalled to duty OT |  |  |  |  |  |  |  |  |  | N/A | N/A |  |  |  |  |  |  |  |  |  |  |  |  | N/A | N/A |  |  |  |  | N/A | N/A |  | No
Monday |  |  |  |  | Professional - 2.3 |  | Normal hours | 06:00:00 | 15:00:00 | 16:00:00 | 19:21:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours | 06:00:00 | 17:00:00 | 18:00:00 | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours | 07:00:00 | 17:00:00 | 18:00:00 | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Recalled to duty OT |  |  |  |  |  |  | N/A | N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Tuesday |  |  |  |  | Professional - 2.3 |  | Normal hours | 05:30:00 | 12:00:00 | 13:00:00 | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Recalled to duty OT |  |  |  |  |  |  | N/A | N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Wednesday |  |  |  |  | Professional - 2.3 |  | Normal hours | 12:00:00 | 15:00:00 | 16:00:00 | 19:21:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours | 12:00:00 | 14:00:00 | 15:00:00 | 19:21:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Recalled to duty OT |  |  |  |  |  |  | N/A | N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Thursday |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours | 06:00:00 | 17:00:00 | 18:00:00 | 19:21:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Recalled to duty OT |  |  |  |  |  |  | N/A | N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Friday |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Recalled to duty OT |  |  |  |  |  |  | N/A | N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Saturday |  |  |  |  | Professional - 2.3 |  | Recalled to duty OT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A | N/A |  |  |  |  | N/A | N/A |  | No
Sunday |  |  |  |  | Professional - 2.3 |  | Recalled to duty OT |  |  |  |  |  |  |  |  |  | N/A | N/A |  |  |  |  |  |  |  |  |  |  |  |  | N/A | N/A |  |  |  |  | N/A | N/A |  | No
Monday |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Recalled to duty OT |  |  |  |  |  |  | N/A | N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Tuesday |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Recalled to duty OT |  |  |  |  |  |  | N/A | N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Wednesday |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Normal hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  | Professional - 2.3 |  | Recalled to duty OT |  |  |  |  |  |  | N/A | N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Total Gross (recalculated)
Ordinary Time Earnings for Superannuation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overtime not classed as OTE (doesn’t count for superannuation) |  |  |  | Meals not classed as OTE (doesn’t count for superannuation)