Spreadsheet: 849444d1699923636-highlighted-cell-date-with-conditional-formating-sample
Sheet: Pay1

Employee Details
Emp. ID: |  | FYR |  |  |  |  | 2022 |  | Month: |  |  | 7 |  |  |  |  |  | Paid | Due | Difference | Adjustment
Surname: |  | Pay | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross Adjustment
First Name(s): |  | Faculty/Division: |  |  |  |  | Su | M | [NAME] | W | Th | F | Sa |  |  |  | Interest 5%
[NAME]: |  | School/Branch: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Superannuation OTE
Meal Allowance Rate: | 24.8
Payday
Fortnight Start Date:
CTFRA
DEET1
PROFESSIONAL EMPLOYEES - RECALCUATIOED FORTNIGHTLY PAY
Day | Date | Public Holiday | Job |  | Step | Hrly rate of pay (inc 25% [NAME]) | Use 24 hour time fomat for start & finish times below (HH:MM) |  |  |  | Hours Claimed | Cumlative Hours per day (H) | [NAME] (Decimal) | Salary $ per job | Daily summary # of normal hrs to be paid as [NAME] | Daily Summary of  Salary $ |  | Meal Allowances | Meal $ | Gross amount | Were you on campus for study or other CDU paid work on this day?
 |  |  |  |  |  |  | Start | Break Start | Break Finish | Finish
Thursday |  |  |  |  |  |  | 08:00:00 | 12:00:00 | 13:00:00 | 16:21:00 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Friday |  |  |  |  |  |  | 08:00:00 | 12:00:00 | 13:00:00 | 16:21:00 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Saturday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A | N/A |  | No
Sunday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A | N/A |  | No
Monday |  |  |  |  |  |  | 08:00:00 | 12:00:00 | 13:00:00 | 16:21:00 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Tuesday |  |  |  |  |  |  | 08:00:00 | 12:00:00 | 13:00:00 | 16:21:00 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Wednesday |  |  |  |  |  |  | 08:00:00 | 12:00:00 | 13:00:00 | 16:21:00 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Thursday |  |  |  |  |  |  | 08:00:00 | 12:00:00 | 13:00:00 | 16:21:00 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Friday |  |  |  |  |  |  | 08:00:00 | 12:00:00 | 13:00:00 | 16:21:00 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Saturday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A | N/A |  | No
Sunday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A | N/A |  | No
Monday |  |  |  |  |  |  | 08:00:00 | 12:00:00 | 13:00:00 | 16:21:00 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Tuesday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Wednesday |  |  |  |  |  |  | 08:00:00 | 12:00:00 | 13:00:00 | 16:21:00 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Total Gross (recalculated)
 | Overtime Calculation in  (4) weeks
Overtime hours | Overtime - Time and a Half. |  | Overtime - Double Time. |  |  |  | Overtime - Double Time and a half. |  | Gross Amount | Meal Allowances | Meal $ | Summary of  Overtime $
 | (Normal + 50%) |  | (Normal + 100%) |  |  |  | (Normal + 150%)
 | 1.5 |  | 2 |  |  |  | 2.5
 | OT Hours | OT Amount | OT Hours |  | OT Amount |  | OT Hours | OT Amount
 |  |  |  |  | Overtime check
1
2