Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jordan231
Contributor II
Contributor II

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

jordan231
Contributor II
Contributor II
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