I'm trying to write a roster template, and need to be able to assign numerical values to shift types (AM/PM 9, MIDDBL 12, DBL 14 and OFF 0). Each week day currently has a drop box for each employee listing the bracketed shift options. Ultimately I want to be able to calculate how many hours are rostered per shift, as well as how many hours each staff member is working. Then extrapolate that info to wage costs per day etc. Trying to do this on 2010, any assistance much appreciated.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!