View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Smooth813 Smooth813 is offline
external usenet poster
 
Posts: 6
Default Converting Baseball Innings when Summed

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.