Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

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
Specialist III
Specialist III

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

Channa
Highlighted
Creator II
Creator II

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