Quote:
Originally Posted by tomcat82
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?