Excel Replay tips: tracking thirds of innings

Scott Fennessy had a question about Excel…

Hi Tom,
Since you seem to be in a mood to show off your excel skills lately I have a simple challenge for you.  In my personal stat sheets I use decimal points for my innings pitched counts.  (i.e. 1.2, 4.1, etc.)  What I recently noticed that my team inning totals, instead of going from .1 to .2 and .3 rounding up to 1 goes from .1 to .9 before rounding up. 

What do I need to fix in my sum equation?
Scott

Okay, this is how I handle it.

If there is a stat column that involves innings, I highlight the cells which data is entered and right click then “Format Cells”.

See the image above to see how I did this.

This will bring up a formatting window for Excel cells. By default, the Number tab is selected at the top. If not, select it.

Then you can choose “Fraction” then “Up to one digit (1/4)“.

Then all I need to do enter in decimal formats for thirds of an inning.

I usually enter in .333 for one third of an inning and .666 for two thirds of an inning. As soon as I hit enter, it immediately changes to the fraction format.

So far, it has worked fine for me. Even Team totals are resolving themselves to one thirds of an inning.

I hope that helps, Scott!