I have Total pay (Currency) earned in one column and duration field in another. How do I calculate my hourly rate per record?
I have only seen how to calculate total pay if you already know the hourly but in this case, I already have the duration and total payout but just need to find out what that means per hour.
Best answer by Julian_E_Post
Hi Josh!
This is very easy to do. When you reference a duration field in a formula, Airtable provides the value in number of seconds. Then you need to divide by 3600 to get hours. So if the pay column is called “Pay” and the duration column is called “Duration”, the formula in a new column “Rate per hour” would be:
Pay/(Duration/3600)
P.S. you can format a formula to show currency by going into the “Formatting” tab in “Customize Field Type”
+13Hi Josh!
This is very easy to do. When you reference a duration field in a formula, Airtable provides the value in number of seconds. Then you need to divide by 3600 to get hours. So if the pay column is called “Pay” and the duration column is called “Duration”, the formula in a new column “Rate per hour” would be:
Pay/(Duration/3600)
P.S. you can format a formula to show currency by going into the “Formatting” tab in “Customize Field Type”
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.