Scheduled Hrs out of preference

[_Melenios_]

Hi amazing team,

I have a realy hard one here and i needed some guidance.

I have a TABLE_1 which holds my employees preferred scheduling time for each day of the week

And  a SCH_Table which holds their real schedules

What i'm trying to get here is on a daily, weekly etc basis is the % of Hours they have scheduled out of their prererences?

Any recommendation where to start would be appreciated.

Thanks!