View Single Post
  #4   Report Post  
Spencer101 Spencer101 is offline
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by tomcat82 View Post
Can't upload files at work, but let me try to explain it...

In baseball, innings pitched are calculated by the amount of batters the pitcher has retired in one inning. He needs to retire three (3) batters to end the inning. So one retired batter amounts 0.1 innings pitched and 3 retired batters to 1.0.

So when a pitcher pitches 6.1 innings in Game 1 and 5.2 innings in Game 2, he has pitched a total of 12.0 innings in 2 games.

Does that help? Normally 6.1+5.2 = 11.3, but in this case it should be 12.0 and so on…

The result should look like:

---A-------------------- B
1 12.0 (B1+B2)----- 6.1
2-----------------------5.2

Does =ROUNDUP(SUM(B1:B2),0) in A1 (with 6.1 in B1 and 5.2 in B2) do the trick?