Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mahitham
Contributor

Difference in Working Minutes help

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

working minutes.png

2 Replies
Channa
Valued Contributor III

Re: Difference in Working Minutes help

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

Channa
Highlighted
mahitham
Contributor

Re: Difference in Working Minutes help

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

netwrokdays.png