Formula to calculate working hours

[thunderthumbs]

Date 1	Date 2	Difference
21/01/2019 08:45:03	1/22/2019 11:01:27 AM <colgroup><col width="155" style="width: 116pt; mso-width-source: userset; mso-width-alt: 5668;"> <tbody> </tbody>

<tbody>
</tbody>

Hi,

I need some help I trying to create a formula between two date / time ranges. The day / time format I m using is 21/01/2019 08:45:03. So I need to calculate the time difference between two dates and times as above example. However there are several exclusions which are :

The hours I need to calculate are working hours between 07:30 and 18:00 Monday to Friday only. Any times and days outside of this need to be ignored.

What's the best / easiest way to do this please ?

 

[thunderthumbs]

Also I need to exclude UK bank holidays as well as weekends thanks

 

[thunderthumbs]

Hi any thoughts thanks ?