Help

Duration to Decimal Calculation Not Accurate - solved!

1290 2
cancel
Showing results for 
Search instead for 
Did you mean: 
JBFriedman
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi all,

I’m using Airtable to track and invoice hours as a freelance designer. I really like the time tracking block, but I’m having trouble converting the duration into an accurate decimal that I can multiply by my hourly rate to get my fee. For example, I have 3:03:00 in my duration column (formatted as h:mm:ss), and the formula in the next column is {Duration}/3660, It returns 3.00, but it should return 3.05, which means I’d be getting shorted a few bucks on my hourly rate calculation. Am I doing this wrong? I want to make sure it’s accurate so that I’m not missing out on revenue. Every penny counts, after all. :winking_face:

Any help is appreciated!

2 Replies 2

I believe it should be {Duration}/3600

JBFriedman
5 - Automation Enthusiast
5 - Automation Enthusiast

Well now I feel silly… Haha! That did it. Thanks!