Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Aug 19, 2020 06:17 PM
Hello, I’m trying to calculate an hourly rate using a duration field and a currency field. I have a formula field that calculates $/hr:
({Earnings}*3600)/{Hours Worked}
However, I have a few records where I don’t have the number of hours worked, just the earnings amount. The formula calculates this as “infinity,” which messes with my sum of the entire column. Is there a way to tell this formula to leave the cell blank if there’s no hours worked?
Solved! Go to Solution.
Aug 19, 2020 06:41 PM
Use this:
IF(
{Hours Worked},
({Earnings}*3600)/{Hours Worked}
)