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.