View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default time calculation for airline standby

Speaking personally I cannot follow what it is you are saying. Can you
please re-state the problem. For example:
tell the total duty allowed time cell to minus all time over 6 hrs ( the
differance between the start of sby and start of fdp cells.

:But the start of your Standby was 06:00 and the start of your fdp (whatever
that is) was 15:00 yet you say that the difference is 6hours when the
figures gives 9 hours.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"khad" wrote in message
...
could anyone help regarding a calculation re the above.

what i am try to do is this: i start a standby at 6:00 and i finish it at
18:00 = 12 hrs
but i am called to work at 15:00, so i have completed 8hrs stby. now i can
only count 6 hrs of this sby time towards my total duty time, so i have to
form a what if type of calculation.

start of sby 06:00 fdp allowed 12:15

start of fdp 15:00 total duty allowed 21:15:00

num of setors 2 max finish time 03:15:00

this calulation above is wrong as i can only work until 00:15 so i need to
tell the total duty allowed time cell to minus all time over 6 hrs ( the
differance between the start of sby and start of fdp cells.

thanks for any help