Quickbase Discussions

 View Only
  • 1.  Over By week

    Posted 05-25-2022 16:13
    Edited by Donnie Burke 05-25-2022 16:16
    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))
    Summary formulas in report settings
    Report


    ------------------------------
    Donnie Burke
    ------------------------------