The purpose of this spreadsheet is to serve as a schedule and completion log for preventative maintenance (PM) assignments. This work will be completed by 4 teams, working 12 hours shift 24/7. I need help with the PM Key tab. My goal is to have the list of PMs listed in the PM key page and have them populate the PM schedule based on start date, cycle in days, and day or night shift (in the PM schedule, the grey rows identify night shift). I have several PMs manually as examples.
Also, the H cell next to each PM is meant to indicate how long it takes to perform each PM in hours. My goal is to calculate how many PM work hours were scheduled to each team and how many they completed by placing their initials next to the PM.