Prev: formula help
Next: Lact cell data copied
From: Smooth813 on 24 Apr 2010 17:32
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.

From: Andre C on 24 Apr 2010 19:10
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)


"Smooth813" wrote:

> 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.
>
 | 
Pages: 1
Prev: formula help
Next: Lact cell data copied