hello - i am trying to sum the number after each letter. the total sum will be added to the correct cell.
example: employee takes V1 ( vacation 1 hour ) and also P4 (sick time). the total hours for each type will be under the correct total hours ( column AH AI AJ )
is this possible to do? I am not sure what formula to use for this one . or is it better to put each type of time off in its own cell?
( Thank you Eric who helped me with the original question! )
example: employee takes V1 ( vacation 1 hour ) and also P4 (sick time). the total hours for each type will be under the correct total hours ( column AH AI AJ )
is this possible to do? I am not sure what formula to use for this one . or is it better to put each type of time off in its own cell?
( Thank you Eric who helped me with the original question! )