Extract number attached to specific character

I’m working on a payroll sheet to print. Under a specific day, I will have something like 8 for one cell (representing 8 regular hours), but sometimes will have 6R 2S (worked 6 regular hours, used 2 sick hours), or 8R 9O (worked 8 regular hours, worked 9 OT). What I want is to extract the number from the cell represented by the letter alone, so I can sum it later. Right now I’m using a lengthy formula SUM(–ISNUMBER(FIND(“8V”,B8:O8))*8)+SUM(–ISNUMBER(FIND(“7.75V…))*0.25). That’s long, but if I could just copy the number in front of the specific letter, I can put those in a table and sum that under the correct column, i.e. Regular, OT, Vacation, Sick, etc.