Summary:
To calculate Overtime Hours based on these conditions:

  • Activity Selection 1, Minimum Work hours for week – 40, Overtime Hours – Over and above the 40 hours to be multiplied by 1.5
  • Activity Selection 2, Minimum Work hours for week – 44, Overtime Hours – Over and above the 44 hours to be multiplied by 1.5

Resolution:
Provide the below given custom formula under Timesheet Detail Report.

If(TotalHours>40&&ActivityName="1",((TotalHours-40)*1.5),If (TotalHours>44&&ActivityName="2",((TotalHours-44)*1.5),0))
 
  Where 1) TotalHours = Total Hours Worked for the week
             2) ActivityName = Name of the Activity selected