Forum Discussion
MarkShnier__You
Qrew Champion
Think that you have a conceptual problem.
The fact is that overtime is overtime. At least where I come from if the employee works more than 40 hours a week then they get paid overtime. So if they worked 30 hours regular time and 20 hours in training and 10 hours non billable, for a total of 60 hours, they worked 20 hours that week then they worked 20 hours of Overtime. The formulas will get enormously complicated to break that out as to which type of time caused the O/T. Because of the way you enter your data I think it is possible to calculate the overtime but you would probably need some outside assistance with the formulas as they will get very complicated.
Or just have one bucket for overtime.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
The fact is that overtime is overtime. At least where I come from if the employee works more than 40 hours a week then they get paid overtime. So if they worked 30 hours regular time and 20 hours in training and 10 hours non billable, for a total of 60 hours, they worked 20 hours that week then they worked 20 hours of Overtime. The formulas will get enormously complicated to break that out as to which type of time caused the O/T. Because of the way you enter your data I think it is possible to calculate the overtime but you would probably need some outside assistance with the formulas as they will get very complicated.
Or just have one bucket for overtime.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
MatthewJones
3 years agoQrew Trainee
Ya that is my issue we have to have the other pay code types because of the industry we are in we have to be able to track and break it down. If it was one over time code the fix you gave me this morning works great but now i have to bucket it out and that' is where I'm banging my head on the wall.
------------------------------
Matthew Jones
------------------------------
------------------------------
Matthew Jones
------------------------------
- MarkShnier__You3 years agoQrew ChampionYou can contact me by my direct email in my signature line if you have a small budget for outside consulting.
I think that the solution will be to have a new "column" on your grid at the right for the running total of the Overtime. You do have an unusual situation where the required fields are all on one record and there is not the complication of child records and which came "first".
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- MatthewJones3 years agoQrew TraineeI sent you over a email to connect.
Thanks
------------------------------
Matthew Jones
------------------------------