Formula to work out business hours between two date fields

[CameronG]

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.

Thanks 🙂