I'm usually quite capable in the way of all things word and excel but want to do something in a workbook that has me stumped

I'm sure it's possible and that I should be able to figure it out, but google and M$ help aren't giving me any answers.

Basically all I want to is :

I have a roster of times but don't want to have type in all the different ones, like 9PM - 10PM, 1AM - 3AM etc but instead just type in say a number or letter.

So in the excel field i would type 1 and it will automatically display the text "9PM - 10PM" or similar.

Any ideas?

I think I'm just having a stupid day today

How does 1 equate to 9-10pm?

You either need a lookup table or a custom filter (assuming I've got the right end of the stick)