Unsure of how to utilize xlookup & IF statements to get my spreadsheet to work

I have a simple spreadsheet I'm putting together to help with payroll submissions for salaried non-traditional shift employees and employees <full-time.    I'm having difficulty when it comes to ho...