Calculating Regular Hours, Over Time, Regular Over Time Night Differential, Night Differen

Hi guys! Can someone help me to compute these:

1. Regular Hours = 8 Hours worked from 06:00 to 22:00

2. Over Time = hours work beyond 8 regular hours within the 06:00 to 22:00
(maybe AFTER or BEFORE the schedule of employee)

3. Regular Over Time Night Differential = Over Time Hours Worked from 22:00 to 06:00
(maybe AFTER or BEFORE the schedule of employee)

4. Night Differential = Regular hours worked from 22:00 to 06:00


Here are the working schedule of employees:

A. 08:00 to 17:00 = 8 hours (1 hour break)
B. 14:00 to 22:00 = 8 hours (no break)
C. 22:00 to 06:00 = 8 hours (no break)
D. 06:00 to 14:00 = 8 hours (no break)


I have attached a sample computation. I would gladly appreciate if someone can help me. Also, I added comment on the files. Please see attached excel file.

Thank you.

Please help? someone?

Hi have I got this right?

1st 8 hours worked at normal rate (depending on shift hours worked)

anything after that is classed as overtime.

do the overtime hours have a ceiling limit

ie 1st 8 hours of overtime paid at 1.5 x hourly rate
then 2nd 8hours of overtime at 2 x hourly rate

can you let me know which way it is