Is there a way to have a field calculate and display time and half pay from an hourly base pay field?
Solved
Calculating 1.5 pay
+8Best answer by MarkShnierYou
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
+24You can say it, we can do it. Can you give an example of what the rules are for paying overtime and what the overtime rate is.
+8I currently have a field where the user enters in their base hourly pay and the overtime rate is at least 1.5 time the amount of the base hourly pay rate.
+8Thank you! So, another issue I've ran into is trying to find the best way to calculate the total pay the employee was paid based off the Total hours worked...
I have a formula duration field that shows the total hours of OT worked based off work start and end times - not sure if I can use the Total Hours of OT worked to calculate the pay based off my OT Pay Rate field that is capturing my time and half pay?
+8I'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)
+8The zero at the end redlines and highlights yellow with a message saying expecting duration but found number? the field is a formula numeric field
+8It's a duration field, but now I've also realized I need to calculate hours between date/time fields.
I have 2 date and time fields for each day of the week for the user to enter in the date work and time started and another field to enter the date and time work stopped - for each day of the week...how do I total those fields in my TOTAL Hours of OT Worked Duration field?
+8Thank you, this is very helpful! My current fields for entering in the date and time is the Date/Time field - should I separate these out and have 2 different fields for the date and time?
+8is there a way to calculate the total pay based off the Total OT hours field and a field that calculates the OT pay rate vs using a standard work week info?
+8Apologies, 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.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.