I need assistance with calculating overtime per week. The scenario is as follows.
Staff are required to work for 48 hours a week and any hours that exceed 48 are regarded as overtime. My solution was to design a duty roster where supervisors create and schedule staff accordingly and the schedule information is saved to a SharePoint list.
So my problem is, that I am not able to get a formula that will make sure that the scheduled hours do not exceed 48 hours while also keeping track of the excess hours. Below are images from the power app.
Solved! Go to Solution.
There is a great article on this that walks you through overtime. This should help Power Apps: Calculate Overtime - Manuel T. Gomes (manueltgomes.com) However I would modify an IF hours are over 48 it returns error that you designate as over. You would nest it in something like this Notify(
First(Errors(Dataset)).Message, "Message here"
@Crullgl thanks for your response. My intended solution is to keep track of the overtime hours in a separate column. For instance, if the intended shift hours + already scheduled hours is more than 48, automatically subtract the total from 48 and post it in the overtime column. However, my formula does not work well. It is not able to accurately keep net scheduled hours to 48.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.