Formula to work out business hours between two date fields

535 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi guys,

I have 2 columns in Grid view, each with date and time. One is a "Created" column, the other is a "Resolved" column.

I am wanting to have a formula to put into a 3rd column / field to work out the business hours between the two other fields. However, I need to be able to specify the working hours start and finish in the formula (having the option here to have 2 shifts would be even better Ie 8-10 and 11:30-16:00), as well as have it exclude certain days of the week (Ie Tuesday, Friday, Saturday). I would also like to be able to list public holidays that it will exclude from the calculation.

Untitled Base_ Table 1 - Airtable and 3 more pages.png

Thanks 🙂

0 Replies 0