Class Schedule with Random Start times

Hello,

I am trying to make a class scheduler. 

Here is what I have already cleaned up and imported.

The class list with length of class, the day and times everyone works.

I have working the "class picker" and "date to schedule".  What isn't working is the time frame for the student.

Lets say a worker shows up for work at 10:00am and works until 6:30pm.

I want to schedule a class at 2:00pm that will end at 4:30pm.

That person is here for that entire time frame, but because his start time is 10:00am the slicer doesn't know to include him.

In excel I could see a "IF(AND(worker start time <= class start time, worker end time<=class end time),"YES","NO"))  But in PowerBi I am struggling.

I believe I need something like Class start time + the Length of the class = X

then

X is <= Workers End Time

I hope that made sense.

I am working on Version: 2.100.1401.0 64-bit (December 2021) of the desktop software.