Counting hours between working hours and days

[jordan231]

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

[Clever_Anjos]

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]

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

[Clever_Anjos]

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