Power App Formula

Job ID: 35478853

Budget: $10 – $30 USD

Need a look up formula to calculate regular and overtime hours per week. First Sharepoint List has the 'Start Date', 'End Date', 'Saturdays?', 'Sundays?', 'Hours per Day', 'Total Regular Hours', and 'Total Overtime Hours'. The second List has 'Date', 'Day'(Sunday-Saturday), 'Day of Week Number'(1-7), 'Week of Year Number'(1-52). I need a formula to calculate the 'Total Regular Hours' and the 'Total Overtime Hours' based on the work days in the week including Saturdays if 'Saturdays?'=Yes and/or including Sundays if Sundays?'=Yes. Hours over 40 hours each week are Overtime.
Related categories: Excel Sharepoint Microsoft PowerApps