Formulas for excel I’m not sure this is the best forum for my question! But here goes. I’m have problems with creating a formula to return a numeric code for a letter i.e. say Holiday =H = 8hours so if there is say five H’s in one row then the total would return a value of 40 . Has anyone got any ideas please. Stevie.