How to Convert Airtable Duration to Hours

You’ve got a duration field in Airtable showing something like 2:30 — but what you actually need is 2.5 hours so you can multiply it by a rate, run a calculation, or export it cleanly.

Sound familiar?

You’re not alone. This is one of the most common Airtable formula questions people run into. The good news? Once you understand one key concept, the whole thing clicks immediately.

This guide walks you through exactly how to convert Airtable duration fields into hours — with copy-paste formulas, real examples, and formatting tips. No guesswork needed.

How to Convert Airtable Duration to Hours

The One Thing You Need to Know First

Here’s the secret that makes everything else make sense:

Airtable stores all duration fields internally as seconds.

That’s it. When you see 1:00 (1 hour) in a duration field, Airtable is actually storing the number 3600 behind the scenes. When you see 2:30, it’s storing 9000.

So to get hours, you just divide by 3600.

Method 1 — Convert Duration to Decimal Hours (Most Common)

This is the formula you’ll use 90% of the time. It converts a duration field into a clean decimal number like 2.5 instead of 2:30.

Formula:

{Duration} / 3600

How to set it up:

1. Create a new Formula field in your Airtable base
2. Paste in {Duration} / 3600 (replace Duration with your actual field name)
3. In the field formatting options, set it to Number → Decimal

Example output:

This is the go-to formula when you want to multiply hours by a rate (like billing $/hr) or sum up total hours across records.

Method 2 — Convert Duration to Hours Using DATETIME_DIFF

If you’re calculating the difference between a start time and an end time, this is cleaner:

Formula:

DATETIME_DIFF({End Time}, {Start Time}, ‘h’)

This returns the number of whole hours between two date/time fields.

Want decimal precision? Divide the minutes version by 60 instead:

DATETIME_DIFF({End Time}, {Start Time}, ‘minutes’) / 60

Use this method when:

• You have separate Start and End date fields
• You’re tracking time logs, task durations, or meetings
• You need to calculate exact elapsed time between two timestamps

Method 3 — Display Duration as Hours + Minutes in Text

Sometimes you don’t want a decimal. You want something readable like “2 hours, 30 minutes” — especially for client-facing reports or dashboards.

Formula:

IF({Duration}>3600, INT({Duration}/3600) & ‘ hour’ & IF({Duration}/3600 >= 2, ‘s’) & ‘, ‘, ”) & INT(MOD({Duration}, 3600)/60) & ‘ minute’ & IF(OR((MOD({Duration}, 3600)/60)>=2, MOD({Duration}, 3600)=0), ‘s’)

Example output:

This formula handles singular vs. plural automatically — so you get “1 hour” not “1 hours”.

Method 4 — Display Duration as HH:MM String

Need the duration formatted as a text string (not a duration field) for concatenation or export?

Formula:

IF(LEN({Duration} & “”) > 0, INT({Duration} / 3600) & “:” & IF((MOD({Duration}, 3600) / 60) < 10, “0”) & MOD({Duration}, 3600) / 60)

This outputs 2:30 as a text string rather than a duration field — which matters when you need to include it inside a longer text formula or export it to another tool.

Note: This formula works for durations under 24 hours. For longer durations, you’ll need to adjust the unit conversions accordingly.

Bonus: Multiply Duration (Hours) by a Rate

Once you’ve converted your duration to decimal hours, multiplying by a rate is straightforward:

Formula:

({Duration} / 3600) * {Hourly Rate}

Example:

• Duration: 2:30 (stored as 9000 seconds)
• Hourly Rate: $75
• Result: (9000 / 3600) * 75 = 2.5 * 75 = $187.50

This is perfect for billing trackers, freelance invoices, and project cost calculations.

Quick Reference: Which Formula to Use?

Conclusion

Converting Airtable duration to hours comes down to one simple fact: duration fields store values in seconds, so dividing by 3600 gives you decimal hours every time.

Here’s what to remember:

• {Duration} / 3600 → decimal hours (for calculations and billing)
• DATETIME_DIFF() → hours between two timestamps
• IF/INT/MOD formulas → human-readable text output
• Format the field as Number/Decimal for clean output

Once this clicks, you can build billing trackers, time logs, productivity dashboards — anything that needs clean hour-based math.