I have a time sheet that where I want to do various totals. When it's hours
worked, no problem. This department also uses letters (P, V, H) to indicate
time off with pay (personal, vacation, holiday). They would also like to use
the lower case version to indicate half a day. How do a get a sum or sumif
function to see the letters as their numeric equivalent and total them with
the other numbers entered?

I know this is probably overly simple for this site, but I can't find it in
the Help section or I can't phrase the question will enough for Help to find
my answer.

Thanks,
--
WJG