Power App Formula

Completed Posted 1 year ago Paid on delivery
Completed 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.

Sharepoint Excel Microsoft PowerApps

Project ID: #35478853

About the project

7 proposals Remote project Active 1 year ago

Awarded to:

(28 Reviews)
4.9

7 freelancers are bidding on average $26 for this job

alamineee

Hi, Dear Employer, I am Al.A. I am a Ph.D. backgrounder and professional data scraper. I will provide you high-quality Excel file. I have worked on similar projects of excel/Excel VBA, Excel Macros, Excel VB Capabiliti More

$20 USD in 1 day
(4 Reviews)
3.4
eduardoherreral4

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

$20 USD in 3 days
(3 Reviews)
3.2
azizva

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

$30 USD in 1 day
(5 Reviews)
3.1
ianm62118

Hello, I am professional freelancer with a Master's degree in Data analytics making me a suitable person for your project. I have more than 8 years of professional experience in Data analysis. Besides, I have skills i More

$50 USD in 1 day
(0 Reviews)
0.0
gradeheroclubltd

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

$30 USD in 2 days
(0 Reviews)
0.0