Converting Baseball Innings when Summed

S

Smooth813

Hey everyone,

Essentially my problem boils down to summing baseball innings in a column.
The data I am copying and pasting comes in the standard form of dictating
innings. Instead of saying 1 and 1/3 inning, baseball translates this as 1.1
innings. Similarly, 1 and 2/3 inning is 1.2.

The problem is that when I sum the innings, it treats dictation such as 1.1
as 1 and 1/10 an inning. So, when summing a row, such as the one below, I
get things such as 455.4 innings, which isn't possible in terms of baseball
dictation.

101.2
105
96
89.1
31
33.1

Is there a way to fix this, either by changing the sum back into baseball
dictation or by translating the dictation into a real number? I'm not sure
if there an easy way to go about this so I thought I would ask for your help.

Thanks.
 
A

Andre C

Hi,

You can use a helper column B (if your innings data is in column A)
INT(A1)+MOD(A1,1)*10/3 and copy down as needed (say from B1:B10)

However, the sum total will need to be recoverted back to your inning format:
INT(SUM(B1:B10))+ROUND(MOD(SUM(B1:B10),1)*3/10,1)

Hope this helps

André
(A baseball fan living in Australia)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top