Need to do a carry over formula
Good morning, I am working on a time card system and have everything working for totals but i am needing to do a formula / rule for over time carry over. So like any time card anything over 40 hours ...
Forum Discussion
I was replying at the same time as Mark. His solution I think is more elegant.
However Mark, I think you have a typo? Overtime total should be Regular Earnings before Cap - 40. Right? And probably include an if statement to only fire when cap field is over 40, so it doesnt show a negative.
------------------------------
Mike Tamoush
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendThx Mike! I have corrected my formula. It was originally wrong but your correction would have driven the [Over Time] to be negative if there were less than 40 hours worked. Anyways, I think between the two of us we have it corrected now
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- Ok i have 1 more thing i got it working but now need to make it complicated lol. So i need to do the over time rule like we just did for Training time and Non-Billable time. But here is the twist they all need to count to the 40 hour rule like we just did so say i have 10 Hours regular pay on Monday Tuesday and Wednesday for a total of 30 hours Reg pay and Thursday i have 10 hours training pay and Friday i have 15 hours training pay and then Saturday 5 hours reg pay for a total of 60 hours i would need to do the same thing but i would need to calculate it all in the total area for the pay type but also do the over time in the over time totals for the pay type
------------------------------
Matthew Jones
------------------------------
