AnsweredAssumed Answered

Figuring Overtime

Question asked by cabarnes on May 24, 2012
Latest reply on Aug 2, 2012 by stephensexton

I have a calculation field that has the total hours worked. I have set up a Regular Time field and also a Overtime Field, both as calculations.

 

In the Overtime field I have the following calculation:

c_PayTime - c_RegHours

 

In the Regular Time field I havethe following calculation:

Case

(

c_PayTime ≥ "8:00" ; "8:00";

c_PayTime < c_PayTime

)

 

This works if the PayTime is over 8 hours, but not if it is less than 8 hours.

 

For example, if the PayTime is 9:30, I would like the Regular field to display 8:00 and the Overtime field to display 1:30. If the PayTime is 7:15, then the Regular field to display 7:15 and the Overtime field to display noting (or 0:00).

 

Thanks,

Craig

Outcomes