Forum Discussion

Qrew Trainee

3 years ago

Over time Rule to Separate hours based on Pay type

Ok I have 1 more issue with creating an overtime rule in the timecard system, this morning I was able to get a 40-hour rule working to move hours from regular Earnings after 40 hours to Regular over ...

App builders

Formulas and functions

MikeTamoush

Qrew Commander

3 years ago

How is overtime calculated? Is it possible in your example it could be 35 hours of Regular time, 5 hours of training pay, and 20 hours of training pay overtime?

I am assuming that as soon as 40 hours hits, then anything after that is overtime. Which means your formulas will be dependent on dates. What happen if you have 35 hours through Friday, then on Saturday both Training and Regular time hit for 5 hours each, which one takes the overtime hit?

I'm not sure the solution right now, but if it is date dependent I suspect it could get fairly involved.

------------------------------
Mike Tamoush
------------------------------

MatthewJones
Qrew Trainee
3 years ago
Right now it is calculated with the fields and formula i posted about using the 3 fields. But yes everything has a date on it, see screen shot below of the time card itself. Right now it is adding it all together and then when it hits 40 it rolls over to the overtime field but im lost on how to separate it into the other over time fields, but it would run like a normal time card and when 40 hours is hit it will start to move everything over time overtime bucket for that pay type.

------------------------------
Matthew Jones
------------------------------