How to Get to Only Business Hours Between Two Dates From 6.00 Am to 9.00 pm

[QVUser1]

Hi,

My business Requirement is like this Buddies,

Iam Having two Dates need to extract the following From Them

• Business Hours From 6.00 am to 9.00 Pm
• Business Hours from 6.00 am to 9.00 Pm and exclude weekends( here in this scenario friday after 9.00 pm hours should not be calculated upto monday 6.00 am)

Regards,

B.Varma

[Anil_Babu_Samineni · Accepted solution]

Create 2 variables for 6 AM and 9 PM then use below

If(Not WildMatch(WeekDay(DateField),'Sat','Sun'), Only({<Time = {'>=v6 <=v9'}>}Time))