I am attaching the excel workbook here.

TeamSchedule.xlsx

I want to create a formula in the cells in column C to retrieve information from the master schedule sheet depending on the date in the "time in schedule" sheet. There are different minutes for each day of the week and Week #. Any help would be greatly appreciated.

Thank you for your assistance.

Newb