Need help on average value of a function over an interval. I am looking for a formula that corrects allocates units from Jul to Dec. So I have 6 months, average km per day is 50 and column G is the interval km per day. I want to get rid of the decimal. instead of having part as 0.5, 0.5, 0.5, 0.5 in 4 months I want to have 0, 1,0,1.
Solved by B. C. in 14 mins