richblake74
Active Member
- Joined
- Dec 30, 2006
- Messages
- 284
- Office Version
- 365
- Platform
- MacOS
Good day all,
I know this will be solved here as you all seem to know this stuff.
I have a Sunrise column "D" (which is performing a vlookup from another sheet.
Col A is a Lift Off time, Col B is Landing time
I would like COL G or col F to perform the following,,, I would like to Subtract the Sunrise time for my Col A lift off and insert my Night Flight time.
If I did not fly at night where my SKIDS UP time is later than SUNRISE col I don't want it to insert the results
Can someone help please?
So in my picture attached all I should get of Night flight time would be 0:02:03
Thank you all.
I know this will be solved here as you all seem to know this stuff.
I have a Sunrise column "D" (which is performing a vlookup from another sheet.
Col A is a Lift Off time, Col B is Landing time
I would like COL G or col F to perform the following,,, I would like to Subtract the Sunrise time for my Col A lift off and insert my Night Flight time.
If I did not fly at night where my SKIDS UP time is later than SUNRISE col I don't want it to insert the results
Can someone help please?
So in my picture attached all I should get of Night flight time would be 0:02:03
Thank you all.