Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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
Highlighted
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
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