Power App Formula
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.