Forum Discussion
Converting text into numbers for sum on a roster
Hello, I am working on a roster that contains a number of different shifts that are for different hours. On the roster, we have different codes so people know what they are working. For example. A...
HansVogelaar , thank you so much for replying.
Yes, you're right the column should calculate 68 hours. My mistake, how embarrassing!
Can you point me in the right direction on how to create an index table?
(How do I create one, where do I contain, how do I access it etc etc)
Thank you again.
The index table is the table in your screenshot, the one with Code and Value as headers. You can place it anywhere. When you create the formula, simply point to the Value column and to the Code column (without the header); Excel will automatically enter the correct reference.