Excel formula question

Hi, looking for help. I have created a drop down list with a number of short patters. What I am now looking for is for a selected shift pattern to automatically populate a cell with he equivalent hours, I.e. cell A1 has a drop down list and I choose 0600-1200 I would like cell B1 to automatically populate with the hours, in this case 6. How do I create this? Many thanks in advance.
By: Chris Swithenbank

Leave a Reply

Your email address will not be published. Required fields are marked *