This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Calculate hours between two timestamps, excluding weekends

Showing results for 
Search instead for 
Did you mean: 
8 - Airtable Astronomer
8 - Airtable Astronomer

Hi folks,

Being able to measure duration between tasks seems to be a fairly common business requirement. So far we have DATETIME_DIFF which is great because it lets you specify the unit of measurement (day, hour, minute etc). However it will also include weekend days. The WORKDAY_DIFF is great as it excludes weekends but unfortunately it only has one unit - day.

So my feature request - either add ‘unit’ as an option to WORKDAY_DIFF or create a new function called WORKTIME_DIFF.