calculation of raised case 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

[swuehl]

Have a look at

Calculate hours between two Date/Time strings

[Gysbert_Wassenaar]

Please don't clutter this site with duplicate discussions: Calculate working hour