Flight time: Calculating number of minutes required by a date to remain current [Updated]

Hi,
As part of our search and rescue drone training we have to have a total of 120 minutes flight time in the last 90 days to remain current.

I want to be able to calculate the next date that a pilot will need to have flown by and how many minutes they will need to stay current.

I have attached a spreadsheet with an example of the table each pilot currently uses ( and a text box containing the requirements outlined above).

I have tried a couple of approaches using match, index and I although I am sure it cannot be as hard as I am making it for myself have not had enough coffee.

Thanks in advance for any assistance!

Cheers
Steve

Welcome to the forum.

Please update your forum profile with the version of Excel you are using for this particular project, or be a bit more specific (as I have been in mine). 'Multiple' tells us precisely nothing that is of any use!

I am not entirely clear how you want this to work: you cannot have a formula and manually entered data in the same cell (once a formula is overwritten, it is gone). I think you might need to have another column that calculates when the next flight should take place.

Hi,
I have updated versions. This spreadsheet is being done on my Mac (Excel 2016).
Thanks
Steve

OK - I'll move this to the appropriate section.

Please see my follow-up comment in post #2 and respond to it.

By the way, assuming version 2016 for Office 365 is wrong: they are not the same, and the latest standalone version is 2019, anyway. 365 is the subscription model, therefore is always up-to-date.

Hi Ali,
The worksheet is for each pilot. The table of the entered data for each pilot is referenced by a summary sheet (where I have sum products etc with calculation of some information required by our team leaders.

I am interested in the formula to calculate the date and number of minutes. It can sit in an additional column or outside in a cell that I can reference. I was struggling with how to identify the correct table row in the formula. I am sure I am missing something obvious

I could possibly do it with VBA but the organisation is very strict about macro enabled spreadsheets and also it limits the amount of resources able to maintain it.

Would it be helpful for me to anonymise the summary sheet as well to provide context or do you have enough information?

Thanks
Steve

I can't do much with this, as there is data missing:

Excel 2016 (Windows) 32 bit

	O	P	Q	R	S	T	U
2	Pilot	Last 90 days	Needed To Gain Currency	Last 80 days	MINUTES NEEDED WITHIN NEXT 10 DAYS	MINUTES WITHIN PRECEEDING 88 DAYS	MINUTES NEEDED WITHIN NEXT 2 DAYS
3		#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
4		#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
5		#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
6		#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
7		#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
8		#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
9	Milligan, Steve	172	0	102	18	172	0
10		#REF!	#REF!	#REF!	#REF!	#REF!	#REF!

Sheet: Summary

Please see post #5 above regarding your version of Excel.

Pl see file
For Date in A17

Please Login or Register  to view this content.

For Time in B17

Please Login or Register  to view this content.

Yes, add a new post to this thread with extra detail - you are not allowed duplicate threads.