Spreadsheet: 161957d1339681666-need-a-formula-to-calculate-overtime-work-schedule-and-salary-calculation-extreme
Sheet: JUL12

 |  | Overtime |  | OVERTIME IN HOURS |  |  | Lunch | Meal | Tpt | Midnight | Acting
Date | Shift | Hours Worked |  | Rest Day | Normal / Off Day |  | Break | Allw | Allw | Allw | Allw | Remarks
 |  | From | To | Day | 1.5 Time | 2.0 Time | For Training | (units) | (units) | (units) | (units)
2012-07-01 00:00:00 | W | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-02 00:00:00 | R | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-03 00:00:00 | O | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-04 00:00:00 | O | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-05 00:00:00 | D | 08:00:00 | 20:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-06 00:00:00 | D | 08:00:00 | 20:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-07 00:00:00 | N | 20:00:00 | 08:00:00 | 0 | 0 | 0 |  | 0 | 0 | 1 |  |  | 0
2012-07-08 00:00:00 | N | 20:00:00 | 08:00:00 | 0 | 0 | 0 |  | 0 | 0 | 1 |  |  | 0
2012-07-09 00:00:00 | W | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-10 00:00:00 | R | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-11 00:00:00 | O | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-12 00:00:00 | O | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-13 00:00:00 | D | 08:00:00 | 20:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-14 00:00:00 | D | 08:00:00 | 20:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-15 00:00:00 | N | 20:00:00 | 08:00:00 | 0 | 0 | 0 |  | 0 | 0 | 1 |  |  | 0
2012-07-16 00:00:00 | N | 20:00:00 | 08:00:00 | 0 | 0 | 0 |  | 0 | 0 | 1 |  |  | 0
2012-07-17 00:00:00 | W | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-18 00:00:00 | R | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-19 00:00:00 | O | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-20 00:00:00 | O | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-21 00:00:00 | D | 08:00:00 | 20:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-22 00:00:00 | D | 08:00:00 | 20:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-23 00:00:00 | N | 20:00:00 | 08:00:00 | 0 | 0 | 0 |  | 0 | 0 | 1 |  |  | 0
2012-07-24 00:00:00 | N | 20:00:00 | 08:00:00 | 0 | 0 | 0 |  | 0 | 0 | 1 |  |  | 0
2012-07-25 00:00:00 | W | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-26 00:00:00 | R | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-27 00:00:00 | O | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-28 00:00:00 | O | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-29 00:00:00 | D | 08:00:00 | 20:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-30 00:00:00 | D | 08:00:00 | 20:00:00 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
2012-07-31 00:00:00 | N | 20:00:00 | 08:00:00 | 0 | 0 | 0 |  | 0 | 0 | 1 |  |  | 0
Earnings |  |  | Unit |  | Amount |  |  | Deductions |  | Unit |  | Amount
Singapore Dollars
OT on OD @ 1.5 |  |  | 0 |  | 0 |  |  | E'yee,CPF-curr.contr |  |  |  | 659
OT on OD @ 2.0 |  |  | 0 |  | 0 |  |  | E'yee, add.fun |  |  |  | 1
OT on RD |  |  | 0 |  | 0
Meal Reimb |  |  | 0 |  | 0
Tpt Reimb |  |  | 0 |  | 0
Night Allowance |  |  | 7 |  | 182 |  |  | GESPP |  |  |  | 890
0 |  |  |  |  |  | 0
Total Earnings in SGD (OT only) |  |  |  |  |  | 0
Total Earnings in SGD |  |  |  |  |  | 3295 | Total Deductions in SGD |  |  |  |  | 1550
 |  |  |  |  |  |  | Net Pay in SGD |  |  |  |  | 1745
EMPLOYER CONTRIBUTIONS (SGD)
Descriptions |  |  |  |  | Contributions | Contributions
E'yer,CPF portion |  |  |  |  | 527.2 |  | CPF OA Account |  |  |  |  | 790.8395399999999
Total Ee/Er CPF cont |  |  |  |  | 1186.2