Power App Formula
$10-30 USD
Paid on delivery
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.
Project ID: #35478853
About the project
Awarded to:
7 freelancers are bidding on average $26 for this job
Hi I have read your description carefully. I have rich experiences in ⭐ PowerBI, Excel, formula, vba, macro, data entry. ⭐ I worked on many similar projects. I can guarantee the quality of the job. Please kindly messag More
Hi, Thank you for posting this project. I read your description and understood well. I can help you in formula. Inbox for discussion. Thank you
Greetings and hoping you are doing well, i welcome you to my profile where quality and client satisfaction is the Priority. I am Expert Juliana and i hope to cooperate with you on your project . CERTIFIED EXPERT IN L More