Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
jacekselega
Contributor
Contributor

Counting hours between working hours and days

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

3 Replies
Clever_Anjos
Employee
Employee

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

jacekselega
Contributor
Contributor
Author

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

Clever_Anjos
Employee
Employee

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