Discussion Board for collaboration on QlikView Scripting.
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
How many working hours a day do you have? Supposing you have 8 this expression can help you with some adjustments
if(WeekDay(vStartDate)<=5, DayEnd(vStartDate) +'08:00:00' - vStartDate, 0) +
if(WeekDay(vEndDate) <=5 , vEndDate - DayStart(vEndDate) + '18:00:00' ,0) +
We starts at 7 am from Mon to Friday. It's 8 hours daily.
you can use my expression as starting point, making your adjusments