I'm hoping to find some way to convert this data into numbers so I can use those numbers for other formulas. I have checked the reporting system of the program I am pulling this info from and I have no choice but to pull this data in this format.
Here's the raw data:
If you have following data in Sheet1:
Then you can try the following formula in cell B2 of "Sheet2":