Cargodawgs
New Member
- Joined
- May 12, 2020
- Messages
- 2
- Office Version
- 2013
- Platform
- Mobile
Hi all,
I’m looking to solving a little project of mind which is a little (actually a lot) out of my punny little brain. My job is to fly from point A to B and it requires me to log in my flight time in day and night hours. Thus I have written my own spreadsheet and this is the last puzzle that I cannot solve.
I'm really looking for something that I can enter as below
Date: 22 Feb 2020
Departure: KDFW (DALLAS) 0314Z
Arrival: EBBR (BRUSSELS) 1215z
And it will pop out with
Flight time: 9:01hrs
Night: 4:51hrs (for example)
There are apps with this function such as mccPILOTLOG. However I would wish to implement it into my spreadsheet so I don’t have to open up another app to check the night hours.
All help is greatly appreciated!
I’m looking to solving a little project of mind which is a little (actually a lot) out of my punny little brain. My job is to fly from point A to B and it requires me to log in my flight time in day and night hours. Thus I have written my own spreadsheet and this is the last puzzle that I cannot solve.
I'm really looking for something that I can enter as below
Date: 22 Feb 2020
Departure: KDFW (DALLAS) 0314Z
Arrival: EBBR (BRUSSELS) 1215z
And it will pop out with
Flight time: 9:01hrs
Night: 4:51hrs (for example)
There are apps with this function such as mccPILOTLOG. However I would wish to implement it into my spreadsheet so I don’t have to open up another app to check the night hours.
All help is greatly appreciated!