Good morning everyone. Is it possible to sum a cell that contains alphanumeric? What I was trying to do is, if a cell contains the letter "S" for sick leave with a number of hours, for instance S-3, on one of the cell, and another cell S-2 in that same row range, then sum it on a specific cell as 5.
I plan on doing this for different types of leave such as V for vacation, C for credit hours, etc.. but with the same concept.
But numeric is the counts of hours, so if there for instance. S-2.5 hour, then I want the sum to consider the sum to the hour. say for example. S-2.5 in cell one, S-4.75 in cell two, then the sum should be 7.25..
Bookmarks