topic Re: Counting hours between working hours and days in QlikView

Counting hours between working hours and days

jordan231 — Tue, 13 Jan 2015 13:28:10 GMT

Dears,

I have two timestamps and i would like to measure exact number of hours between those two dates.

The case is i would like to exclude all holidays in our comapny and to make this more complicated i need to take into account also working hours in company. Any ideas ?

Thanks in advance for your help

/jacek

Re: Counting hours between working hours and days

Clever_Anjos — Tue, 13 Jan 2015 13:42:02 GMT

How many working hours a day do you have? Supposing you have 8 this expression can help you with some adjustments

=Interval(

if(WeekDay(vStartDate)<=5, DayEnd(vStartDate) +'08:00:00' - vStartDate, 0) +

if(WeekDay(vEndDate) <=5 , vEndDate - DayStart(vEndDate) + '18:00:00' ,0) +

RangeMax(NetWorkDays(vEndDate+1,vEndDate-1,Feriados),0)*8/24

)

Re: Counting hours between working hours and days

jordan231 — Tue, 13 Jan 2015 13:53:09 GMT

We starts at 7 am from Mon to Friday. It's 8 hours daily.

Re: Counting hours between working hours and days

Clever_Anjos — Tue, 13 Jan 2015 13:55:17 GMT

you can use my expression as starting point, making your adjusments