I am creating a timesheet report that calculates a running total of hours for the week by day. However, I want to be able to create two running totals for the entered time for the week. One that will max at 40 hours (reg. hours) and the second will start after 40 hours (overtime).
Any ideas?
Thanks!Use two Running totals
Reset first when it reaches 40
and start other when it over 40sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment