I'm trying to have Excel compute Post Mission Crew Rest for aviators. We are allowed after 16 hours of being away 1 hour for every 3 hours away not to exceed 96 hours. I want to then add that date and time to the individual's return date and time (C10 and D10). Thank you in advance for your help!!!
Example:
B C D
7 Mission Takeoff Time 21-Mar 23:00
8 Mission Land Time 28-Mar 23:00
9 Mission Duration-Hours 168:00
10 PMCR Date/Time 31-Mar 7:00
Bookmarks