topic Re: Calculate working hour in QlikView

Calculate working hour

balrammahato204 — Mon, 01 Jun 2015 13:52:41 GMT

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

Re: Calculate working hour

Gysbert_Wassenaar — Mon, 01 Jun 2015 13:55:22 GMT

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

Re: Calculate working hour

swuehl — Mon, 01 Jun 2015 13:55:37 GMT

Please try to avoid cross-posting.

Calculate hours between two Date/Time strings

Re: Calculate working hour

maxgro — Mon, 01 Jun 2015 13:59:44 GMT

there is an interesting discussion on the same question here

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