Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-27-2019, 11:46 AM
GregM GregM is offline Rounding to split up times. Mac OS X Rounding to split up times. Office 2011 for Mac
Novice
Rounding to split up times.
 
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
  #2  
Old 03-27-2019, 11:58 PM
ArviLaanemets ArviLaanemets is offline Rounding to split up times. Windows 8 Rounding to split up times. Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Having flight times as time, not the number of hours, makes things much easier! I don't think, pilots will measure the time with accuracy of second (or less)

In attachment, time cells are formatted in a way what allows flight hours over 24 hours.

Currently the attachment is only for schedules where all hours are distributed evenly. When you want the possibility e.g. for some pilot have only left seat, and another only right seat, then you must add a column where you enter the schedule number (e.g. when 1 then 2*Left+Out, when 2 then 2*Right+Out, when 3 then Left+Right+Out) and correct formulas in table tFTTable accordingly.
Attached Files
File Type: xlsx FlightTimes.xlsx (11.0 KB, 7 views)

Last edited by ArviLaanemets; 03-28-2019 at 02:25 AM.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Split word file into several PDF using the bookmarks as split positions and name Fixxxer Word VBA 7 10-08-2018 01:10 AM
Split function in Excel (split the screen) Officer_Bierschnitt Excel 1 07-05-2017 07:02 AM
Custom rounding up paulkaye Excel 8 09-03-2016 11:12 PM
Rounding to split up times. Excel Seems to be Rounding Twice Rather Than Once melissapete24 Excel 5 08-27-2016 12:51 AM
Rounding to nearest 0.25 Guloluseus Excel 5 10-27-2015 11:28 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:30 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft