I have figured out a formula and then formatted the cells appropriately to get them the way I need them to look. I couldn't upload the document but attached are two screenshots of the values and the corresponding formulas.

Thanks to MyVeryOwnSelf for showing me the 13/24. Couldn't have figured it out with that!