Skip to main content (Press Enter).
Skip auxiliary navigation (Press Enter).
Skip main navigation (Press Enter).
Back to discussions
Over By week
Over By week
Posted 05-25-2022 16:13
Edited by Donnie Burke 05-25-2022 16:16
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.
If([hours_to_number (tot)]<40,[hours_to_number (tot)]))
If([hours_to_number (tot)]>40,Max(0,[hours_to_number (tot)]-40))
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Powered by Higher Logic