Hi,
I need some help constructing a worksheet that will help me calculate time. This spreadsheet will be used to calculate flight time on a rolling 24 hour clock. I know how to convert hours to mins and show the difference between times.
As an example - here is a what I need to calclulate. A crewmember is only allowed to fly a total of 10 hours in a 24 hour period. The 24 hour clock is a rolling clock.
A flight departs at 1400 and blocks in at 1630. Blocks back out at 1730 and blocks back in at 2230. The 24 hour clock began at 1400. The total flight time is 7.5 hours. Crew goes into rest and begins flying the next day. They depart at 1030 and block in at 1300. They are still on the same 24 hour clock and now have 10 hours of flight hours. Say they are supposed to depart at 1345 but since they are in the same 24 hour period, they will exceed 10 hours of flight time. I need something set up in excel that will calculate the time in the 24 hour period and tell me when they are legal to depart. In this example, they would be legal to depart at 1400 because they would begin dropping flight time from the previous day (the rolling 24 hour clock). It is possible to drop flight time and accumulate flight without exceeding since it is a rolling clock.
Anyone out there that can help me with this? I would be forever grateful for any tips on how to set this up!It is sort of difficult to figure on paper and I've been toying with Excel to help me out.
Anyone may email me directly at skysim70@sbcglobal.net with suggestions.
Thanks so much!
Bookmarks