Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
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, 9 views)

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



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 09:06 PM.


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