View Single Post
 
Old 03-27-2019, 11:46 AM
GregM GregM is offline Mac OS X Office 2011 for Mac
Novice
 
Join Date: Mar 2019
Posts: 1
GregM is on a distinguished road
Default 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!
Reply With Quote