I have a form where users select if they performed over-hours or minus-hours and a duration field.
In this field they only select the duration, for example 02:00 (hours).
To calculate the total balance i would like to create an "actual duration" field, where the plus or minus sign will be added based on the selection of the user.
I tried with an IF formula but I can't get it working...
IF([Request Type]="Minus Hours", -[Duration], [Duration])
Can you please help?