To enable Excel to "translate" your shift codes into hours
I think you will have to have an extra row or column to
coincide with your list of codes. This could be hidden or
well away from your daily codes.
You could do the job with "nested If's" but these can be a
pain to set up. I would use VLOOKUP().
Have a named range where your codes and their value are
listed and then refer to this range. In the following
example from a sample workbook I have just tried
=VLOOKUP(B6,shiftcode,2,FALSE)
It is much easier to explain in an Excel workbook itself
which I would be happy to send direct to you and anyone
else who is interested.
Regards
Tony
Rutland UK
The NOSPIN Group has added a new feature on our website,
web based bulletinboard for questions and answers:
Visit our sister website at http://nospin.com
|