I am building a spreadsheet designed to keep track of employee hours. One of the things I would like to do is enter the text PTO into the cell, and have it return a numerical value of 8 for the purposes of my total hours.

Is there a way to have a formula recognize a text entry as a numerical value? I imagine it has to be part of the sum formula, telling it to treat "PTO" as though I had entered 8.