Calculate Overtime Per Week

[eetigu]

Hi Guys,

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. 

Shift CreationShift View

Thanks.

Emma.

[Crullgl]

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"
NotificationType.Error
))

[eetigu]

@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.

Thanks

[Crullgl · Accepted solution]

you could do it in power apps or have it done in the list itself so use a calculated column =IF([Hours] >40, [Hours]-40, 0)

[eetigu]

@Crullgl I implemented something similar to your solution. Thanks