Rounding to split up times.
I have an excel spreadsheet to divide up aircrew flight times when you enter in total time. Usually three pilots divide up their times three ways between left seat, right seat, and out of the seat (rest) time. So three rows for three pilots, and three columns for each seat. Is there a way I can get some cells to round up OR down the .X3333 or .X6666 as appropriate so the rows and columns add up correctly to the total time?
E.g.:
Position:LEFT|RIGHT|OUT
...Pilot1: 2.9 | 2.8 | 2.8
...Pilot2: 2.8 | 2.9 | 2.8
...Pilot3: 2.8 | 2.8 | 2.9
Total:8.5
Or
Position:LEFT|RIGHT|OUT
...Pilot1: 2.9 | 2.9 | 2.8
...Pilot2: 2.9 | 2.8 | 2.9
...Pilot3: 2.8 | 2.9 | 2.9
Total:8.6
Thanks!
|