Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
)
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