Hello,
OVERTIME BY WEEK I'm having trouble working out overtime in a summary report. I have a daily time card with [Time In] [Time Out] and it gives me ours worked per day, every day a new record is created with the time in time out. The state of Louisiana mandates overtime as (everything after 40 hours in a week is overtime, not anything over 8 hours per day) I need a report that will total all the standard hours and overtime ours for all employees or all projects project. This is easy if i use only one employee but if i have more than one employee i find the report will stop counting standard ours. Im including a screenshot this is as close as I've gotten you can clearly see these totals are in correct
Here are my formulas. These formulas are in "Summary Formulas" in the summary report.
Standard time
s_tandard
If([hours_to_number (tot)]>40,40,
If([hours_to_number (tot)]<40,[hours_to_number (tot)]))
Overtime
If([hours_to_number (tot)]>40,Max(0,[hours_to_number (tot)]-40))
------------------------------
Donnie Burke
------------------------------
Question
Over By week
This topic has been closed for replies.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.