Can someone help me build an excel template query?

Hi. I need help making a schedule template in excel based off a template from Shifts for Teams. I made a post before here: https://answers.microsoft.com/en-us/msoffice/forum/all/can-i-duplicate-spreadsheets-with-formulas/dc6b0209-f04a-40ee-830a-96b6829853d5. Volunteer Andreas Killer built the template before, and I need help again. Can someone help? Basically, I need the same thing, except the query needs to read the time input as [8:00 am - 4:30 pm] instead of [8:00]. And there a no unpaid breaks on Sundays.