Calculate Business Hours which include Saturdays and Sundays

[bahare76]

Dear Colleagues, 

I have created a column on determining the business hours. My challenge is to include Saturday and Saturday as non-business hours. Here is what I have made so far.

Bss Hours ? = IF(OR('Master'[Time]<TIME(08,30,00),'Master'[Time]>TIME(18,00,00)),"No","Yes")

[amitchandak · Accepted solution]

@bahare76 ,

Bss Hours ? = IF(OR('Master'[Time]<TIME(08,30,00),'Master'[Time]>TIME(18,00,00)) || weekday([date],2) >=6 ,"No","Yes")

[bahare76]

Thanks @amitchandak