Formula to calculate working hours

[thunderthumbs]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date 1
[/TD]
[TD]Date 2
[/TD]
[TD]Difference
[/TD]
[/TR]
[TR]
[TD]21/01/2019 08:45:03
[/TD]
[TD][TABLE="width: 116"]
<colgroup><col width="155" style="width: 116pt; mso-width-source: userset; mso-width-alt: 5668;"> <tbody>[TR]
[TD="width: 155, bgcolor: white"]1/22/2019 11:01:27 AM
[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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 ?