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:
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).