Forum Discussion

LB's avatar
LB
Qrew Cadet
11 days ago

Calculating 1.5 pay

Is there a way to have a field calculate and display time and half pay from an hourly base pay field?
formulas
  • MarkShnier__You's avatar
    MarkShnier__You
    11 days ago

    OK, np.

    It's similar to Excel.  Just make a new field of type formula numeric and the formula would be like

    [base hourly pay rate] * 1.5

    You probably have to adjust to your own field name unless I guessed correctly.  There is a field picker at the bottom of the formula box where you can choose from your existing fields 

     

LB's avatar
LB
Qrew Cadet

I've tried this formula, but it doesn't seem to be working...

If([TOTAL Hours OT Worked] > [Standard Work Week], 

    ([TOTAL Hours OT Worked] - [Standard Work Week]) * [OT Pay Rate],
    
    0)

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
10 days ago

Try this

If([TOTAL Hours Worked] > [Standard Work Week], 

    [TOTAL Hours OT Worked] * [OT Pay Rate],
    
    0)