hi all again

after sorting 1 problem out i have found that i have another calculation
problem, if anyone can help with a formula please.


Local Time of Starts
Sectors
1 2 3 4 5 6 7 8 or more
06:00-07:59 13:00 12:15 11:30 10:45 10:00 09:30 09:00 09:00

08:00-12:59 14:00 13:15 12:30 11:45 11:00 10:30 10:00 09:30

13:00-17:59 13:00 12:15 11:30 10:45 10:00 09:30 09:00 09:00

18:00-21:59 11:15 10:30 09:45 09:30 09:00 09:00 09:00 09:00

22:00-05:59 11:00 10:15 09:30 09:00 09:00 09:00 09:00 09:00






Start of SBY 11:00 FDP Allowed 12:15

Start of FDP 17:00 Total Duty Allowed 18:15

No, of Sectors 2 Max Finish Time 05:15

sorry the sheet details havent quite pasted here very well, but the problem
i have is when i wish to start my standby in a differant time bracket e.g
08:00-12:59, now i have to tell the fdp allowed collum to recognise the duty
times allowed within that bracket e.g 2 sectors allowable fdp = 13:15. the
fomula i have in fdp allowed cell at the moment is this
=IF(D29=E9,E10:E18,IF(D29=F9,F10,IF(D29=G9,G10,IF( D29=H9,H10,IF(D29=I9,I10,IF(D29=J9,J10)))))).
which only covers the times from 06:00-07:59 sectors flown with allowable
duty time e.g 2 sectors = 12:15.

thanks for any help and this would then solve the worksheet.