Calculate working hour

[balrammahato204]

Hi,

I was wondering if someone would be able to help me with this query.  I am new to Qlikview and my query is
calculation of raised case working hour:
Working hour for everyday is 8:00 am to 6:00 Pm.

for example i have one case is assigned on 02-01-2015 and closed on 03-03-2015 then how to calculate the work hour exclude all weekend and all uk bank holidays.

Thanks and Regards

Balram

[Gysbert_Wassenaar]

This discussion may help: Calculate hours between two Date/Time strings

[swuehl]

Please try to avoid cross-posting.

Calculate hours between two Date/Time strings

[maxgro]

there is an interesting discussion on the same question here

https://community.qlikview.com/thread/60227