i would like to know if excel could seek out a certain letter eg(E) and turn
it in to a number eg e=15:00 as in what time the work shift finnishes. need
to know a formula for it tried the "if" formula. =if(a2="E","15:00") which
works untill you tell it too look in more then one cell because the cells
have a mixture of E , LM , MID all diferent shifts. get my drift?