Thread
:
time calculation for airline standby
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
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
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann