I am trying to set up a staff rota in Excel 2003. Can I enter letters to
represent not only the shifts but also the hours of the shift e.g. E = Early
shift, 8 hours,L=Late shift,7.5 hrs,X=day off, that can then be added
together with other shifts to check total hours worked?e.g
would return total..
M T W Th F S Total
VM L E L E E X 39
NJ E L E L E X 39
BH L L E L E X 38.5
Thanks.