Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Overtime calculation

I am trying to calculate weekly over time of total Duration. The formula(s) that I am currently using are: TotalHours = SUM(HoursData[Duration]) Overtime = IF([TotalHours] > 37.5, IF(([TotalHo...
Need Help
Padycosmos's avatar
Padycosmos
Solution Sage
3 years ago

Hope this helps:

Overtime =SWITCH(TRUE(),[TotalHours]-37.5>6.5, 6.5,[TotalHours]-37.5)<=6.5, [TotalHours]-37.5,0)

Padycosmos's avatar
Padycosmos
Solution Sage
3 years ago

Hope this helps:

Overtime =SWITCH(TRUE(),[TotalHours]-37.5>6.5, 6.5,[TotalHours]-37.5)<=6.5, [TotalHours]-37.5<=0,0)

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Padycosmos - It says there is a syntax error

    • Padycosmos's avatar
      Padycosmos
      Solution Sage
      3 years ago

      Sorry about that, here's the corrected one

      Hope this helps:

      Overtime =SWITCH(TRUE(),[TotalHours]-37.5>6.5, 6.5,[TotalHours]-37.5)<=6.5,[TotalHours]-37.5, [TotalHours]-37.5<=0,0)