Difference in Working Minutes help

[mahitham]

Hi Experts,

Can any one please help me on below requirement.

I have two date fields like below. From these Two date please help me to calculate the Time Difference in Working Minutes.

A “working minute” is defined as any minute that falls between the hours of 09:00 and 17:30 on any Monday, Tuesday, Wednesday, Thursday or Friday that is not a bank holiday date in England in the relevant year.

Please help me on this.

Thanks in advance

[Channa]

networkdays(Currdate, Adddate,vHolodays) * 24 & Interval(time(frac(Currdate))-time(frac(Adddate)),'HH:mm')

[mahitham]

Hi @Channa 

Thanks for your help.

Could you please explain  the below logic  why its included in the expression. When I have taken below part in a separate expression I am getting  0's

networkdays(Currdate, Adddate,vHolodays) * 24