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
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
------------------------------
------------------------------
Matthew Jones
------------------------------