Hello,
Similar to this solution, I am looking for a slight modification for pilot's time and I can't figure it out:
http://www.mrexcel.com/forum/excel-questions/662103-day-night-shift-calculation.html
Here are the rows and columns I have:
<colgroup><col span="3"><col span="2"><col><col><col></colgroup><tbody>
</tbody>
I need something like this very similar for my pilot logbook spreadsheet. The only difference is that my total time is already calculated for me and I'm able to import into the spreadsheet along with the start and end times for my flights. Here's the catch, my total time takes into account any time change that took place from takeoff and landing. So, therefore, the total time might only show 1 hr flight time when you look at the takeoff and landing time and it's 2 hours difference due a time change from say Central time zone to Eastern time zone. Therefore I don't use the formula for total time like you have in the example above (D2).
So, how would you need to change up the formula in order to compensate for time zone changes? Because there are many times when I cross time zones so the Dep and Arr times are reflective of local times and not total duration of the flight.
Have I confused you yet? Lol. Let me know if you might have a solution. I can email you the spreadsheet so you can possibly help me out. I truly appreciate it!!!
Tony
Similar to this solution, I am looking for a slight modification for pilot's time and I can't figure it out:
http://www.mrexcel.com/forum/excel-questions/662103-day-night-shift-calculation.html
Here are the rows and columns I have:
| From | To | Legs | Dep | Arr | Duration | Day | Night |
| JFK | IAD | 1 | 7:15 AM | 8:24 AM | 1:09 | ||
| IAD | JFK | 1 | 9:05 AM | 10:15 AM | 1:10 | ||
| JFK | HOU | 1 | 1:17 PM | 4:12 PM | 3:55 | ||
| HOU | JFK | 1 | 7:00 AM | 11:20 AM | 3:20 | ||
| JFK | MCO | 1 | 2:09 PM | 4:47 PM | 2:38 | ||
| MCO | BOS | 1 | 5:52 PM | 8:40 PM | 2:48 | ||
| BOS | DEN | 1 | 9:20 PM | 12:00 AM | 4:40 | ||
| DEN | BOS | 1 | 12:10 AM | 5:27 AM | 3:17 |
<colgroup><col span="3"><col span="2"><col><col><col></colgroup><tbody>
</tbody>
I need something like this very similar for my pilot logbook spreadsheet. The only difference is that my total time is already calculated for me and I'm able to import into the spreadsheet along with the start and end times for my flights. Here's the catch, my total time takes into account any time change that took place from takeoff and landing. So, therefore, the total time might only show 1 hr flight time when you look at the takeoff and landing time and it's 2 hours difference due a time change from say Central time zone to Eastern time zone. Therefore I don't use the formula for total time like you have in the example above (D2).
So, how would you need to change up the formula in order to compensate for time zone changes? Because there are many times when I cross time zones so the Dep and Arr times are reflective of local times and not total duration of the flight.
Have I confused you yet? Lol. Let me know if you might have a solution. I can email you the spreadsheet so you can possibly help me out. I truly appreciate it!!!
Tony
