Power Query: Date/Time Falls Between Business Hours

Hi IamTDR ，

First go to query editor> split columns :Split the date/time columns into 2 columns: date and time,as you see below:

Then create a calculated column to get the weekday of the field "create at"：

Weekday = FORMAT(WEEKDAY('Table (2)'[Create at.1],1),"DDDD")

Finally create 2 measures as below:

is within 2 hours = 
var a=DATEDIFF(MAX('Table (2)'[Create at.2]),MAX('Table (2)'[the first response.2]),MINUTE)/60 Return
IF(a<=2,1,0)

is within business hours = IF(MAX('Table (2)'[Weekday]) in FILTERS('Table'[Weekday ])&&MAX('Table (2)'[Create at.2])>=MAX('Table'[Working hour start ])&&MAX('Table (2)'[the first response.2])<=MAX('Table'[Working hour end]),1,0)

And you will see:

For the related .pbix file ,pls click here.