Day Shift:
Working Hour:
(Mon-Fri) 8.30am-5.30pm (8 hrs with 1 hr lunch break)
(Sat) 8.30am-12.30am
Overtime:
Rate x1.5 - (Mon-Fri) Before 8.30am & After 5.30pm
- (Sat) After 1.30pm (lunch break 12.30pm-1.30pm is not given as OT)
Rate x2.0 - SUNDAY, PUBLIC HOLIDAY
Night Shift:
Working Hour:
(Mon-Fri) 8.00pm-5.00am (8 hrs with 1 hr lunch break)
(Sat) 8.00pm-12.00am
Overtime:
Rate x1.5 - (Mon-Fri) Before 8.00pm & After 5.00am
- (Sat) After 12.00am
Rate x2.0 - SUNDAY, PUBLIC HOLIDAY
The calculation will be much more complicated for Night Shift Overtime.
For example:
sample.JPG
The OTx1.5 & OTx2.0 is the total hour works.
If the public holidays falls on Weekdays, the overtime calculation will be even more complicated:
sample.JPG
I have no idea how should I generate the formulas to calculate the overtime for this, anyone could help me?
Bookmarks