Forum Discussion

CoreyP's avatar
CoreyP
Icon for Solution Sage rankSolution Sage
8 years ago

Overtime Calculations...? STUMPED!

Hey you, Guru!   Okay, so here's the rub... I work in a warehouse-type facility, doing logistics. We have MANY "business units" and MANY "activities."  An activity describes the task the employee...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

well explained, basically these are the business rules:

 

1. Daily work more than 8 hours is treated as overtime

2. Sum of hours in a week (week = monday to sunday) > 40 hours will be treated as overtime

 

Is this correct understanding?

 

As I always request, drop some data in excel sheet, it will help.

CoreyP's avatar
CoreyP
Icon for Solution Sage rankSolution Sage
8 years ago

That's kind of the jist. 

 

               Table = WEEK

Date             |       Hours      |         OT

 

Monday               7.50

Tuesday               8.33               

Wednesday          9.1                 

Thursday              6.79

Friday                   7.40

Saturday               0

Sunday                 0

 

In the above example, even though the employee went over 8 hours on two days, technically, did not work any overtime because the total amount of hours is less than 40, at 39.12.

 

It's like ONLY if the total is greater than 40, then the days over 8 are overtime. 

 

Here's a week's worth of labor data. Last names removed for security. CLICK HERE FOR *.xlsx labor example