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 would change the regular earnings total field into a hidden (you can remove from form) field called 'Total Hours'.
Then your regular earnings field and overtime fields are simply formulas looking at that field.
Regular Formula says, if total hours are less than or equal 40, then show total hours, else show 40.
Over time says if total hours are under 40 show 0, otherwise show total hours minus 40.
------------------------------
Mike Tamoush
------------------------------
Then your regular earnings field and overtime fields are simply formulas looking at that field.
Regular Formula says, if total hours are less than or equal 40, then show total hours, else show 40.
Over time says if total hours are under 40 show 0, otherwise show total hours minus 40.
------------------------------
Mike Tamoush
------------------------------