Forum Discussion

LB's avatar
LB
Qrew Cadet
8 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
    8 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
4 days ago

Apologies, let me try to clarify - I have a formula field that will calculate the Total OT Pay based on the Total Hours worked * OT Pay rate...but I also need to calculate based off of an exempt type employee who receives a per-diem rate. I'm not sure how to have the Total OT Pay reflect how much a per-diem person will receive.